Olmo, 1. Your web site statates, that there is no other multi db commercical dbling provider. This is wrong. Some ADO .NET driver creators are created dlinq providers. Also Llblgen Pro has also multi-db linq provider. You can check in their web site how its author Frans Bouma has solved this:
LLBLGen Pro website: http://www.llblgen.com .NET blog: http://weblogs.asp.net/fbouma 2. Entity framework has also SelectMany() and supports multiple databases. For example npgsql.org has EF provider for PostgreSql. You can also look how this is solved in EF. 3. btw, How about merging your and dblinq projects together ? Having two separate projects with compatible license is wasting resources. Andrus. ----- Original Message ----- From: "guadalupe1983" <[email protected]> To: "DbLinq" <[email protected]> Sent: Saturday, March 14, 2009 1:33 PM Subject: Re: SelectMany & Signum Framework Hi Pascal, SelectMany operator is more general than a Join / Outter Join. In many cases you can reduce it to joins but not always, and is a hard work to do it. SQLS 2005 included CROSS APPLY operation, that is the SQL equivalente to SelectMany, we use it and that's why is not easy for us to be database independent Take a look here: http://blogs.msdn.com/mattwar/ Did you use Matt Warren's post to do the provider, I haven't seen Visitor in the source code. Olmo,. On 13 mar, 14:51, Pascal Craponne <[email protected]> wrote: > Hi Olmo, > I'm not sure I understand your question. > The SelectMany() method is supported in DbLinq. > What is a "Cross Apply"? > > Pascal. > > jabber/gtalk: [email protected] > msn: [email protected] > > On Fri, Mar 13, 2009 at 12:13, guadalupe1983 <[email protected]> wrote: > > > Hi, > > > My name's Olmo. I'm the developer responsible of Signum Framework, an > > open source framework that also has a Linq provider. > > >http://www.signumframework.com/DatabaseQuery.ashx > > > Our aim is quite different to yours, we focus on an Entites-first > > approach, generating the tables from C# entities not the other way > > arround. > > > We are not considering moving to non-MSSQL because there's no way to > > map SelectMany in the general case if you don't have a Cross Apply. > > > How did you solve that? I've downloaded the source code but I haven't > > seen any provider. > > > BTW, I hope there's no problem in saying that DbLinq stills in a > > prototype stage, as you say so in your site. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dblinq?hl=en -~----------~----~----~----~------~----~------~--~---
