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 -~----------~----~----~----~------~----~------~--~---
