Hi Tony,
does the problem still exist? Joins have changed a lot recently, hopefully
for the best :)
Let me know!
Pascal.
On Tue, Jul 22, 2008 at 08:28, Pascal Craponne <[EMAIL PROTECTED]> wrote:
> Hi Tony,
>
> joins are not mature at the moment: simple inner joins work correctly, but
> not much more. That's one of the next important tasks. Anyway I'll take a
> look at your error and see if I can do a quick fix.
>
> Pascal.
>
>
> On Tue, Jul 22, 2008 at 02:17, Tony Alexander Hild <[EMAIL PROTECTED]>
> wrote:
>
>> Hi,
>>
>> When I try to retrieve an associated element with this expression using
>> join clause
>>
>> var foos =
>> from f in db.Foos
>> join b in db.Bars
>> on f.BarID equals b.BarID
>> select new { Foo = f, Bar = b};
>>
>> and this database
>>
>> CREATE TABLE IF NOT EXISTS [Foo]
>> (
>> [FooId] GUID UNIQUE NOT NULL PRIMARY KEY,
>> [BarId] GUID CONSTRAINT fk_Bar_BarId REFERENCES Bar (BarId)
>> );
>>
>> CREATE TABLE IF NOT EXISTS [Bar]
>> (
>> [BarId] GUID UNIQUE NOT NULL PRIMARY KEY
>> );
>>
>> I'm getting this exception
>>
>> 1010
>>
>> at DbLinq.Vendor.Implementation.SqlProvider.GetLiteral(ExpressionType
>> operationType, IList`1 p) in
>> d:\dev\work\colaboration\dblinq\DbLinq\Vendor\Implementation\SqlProvider.cs:line
>> 263
>> at
>> DbLinq.Data.Linq.Sugar.Implementation.SqlBuilder.BuildExpression(Expression
>> expression, QueryContext queryContext) in
>> d:\dev\work\colaboration\dblinq\DbLinq\Data\Linq\Sugar\Implementation\SqlBuilder.cs:line
>> 161
>> at
>> DbLinq.Data.Linq.Sugar.Implementation.SqlBuilder.BuildExpression(Expression
>> expression, QueryContext queryContext) in
>> d:\dev\work\colaboration\dblinq\DbLinq\Data\Linq\Sugar\Implementation\SqlBuilder.cs:line
>> 121
>> at
>> DbLinq.Data.Linq.Sugar.Implementation.SqlBuilder.BuildSelect(Expression
>> select, QueryContext queryContext) in
>> d:\dev\work\colaboration\dblinq\DbLinq\Data\Linq\Sugar\Implementation\SqlBuilder.cs:line
>> 280
>> at
>> DbLinq.Data.Linq.Sugar.Implementation.SqlBuilder.Build(SelectExpression
>> selectExpression, QueryContext queryContext) in
>> d:\dev\work\colaboration\dblinq\DbLinq\Data\Linq\Sugar\Implementation\SqlBuilder.cs:line
>> 80
>> at
>> DbLinq.Data.Linq.Sugar.Implementation.SqlBuilder.BuildSelect(ExpressionQuery
>> expressionQuery, QueryContext queryContext) in
>> d:\dev\work\colaboration\dblinq\DbLinq\Data\Linq\Sugar\Implementation\SqlBuilder.cs:line
>> 67
>> at
>> DbLinq.Data.Linq.Sugar.Implementation.QueryBuilder.BuildSqlQuery(ExpressionQuery
>> expressionQuery, QueryContext queryContext) in
>> d:\dev\work\colaboration\dblinq\DbLinq\Data\Linq\Sugar\Implementation\QueryBuilder.cs:line
>> 329
>> at
>> DbLinq.Data.Linq.Sugar.Implementation.QueryBuilder.GetSelectQuery(ExpressionChain
>> expressions, QueryContext queryContext) in
>> d:\dev\work\colaboration\dblinq\DbLinq\Data\Linq\Sugar\Implementation\QueryBuilder.cs:line
>> 387
>> at DbLinq.Data.Linq.Implementation.QueryProvider`1.GetQuery(Expression
>> expression) in
>> d:\dev\work\colaboration\dblinq\DbLinq\Data\Linq\Implementation\QueryProvider.cs:line
>> 100
>> at
>> DbLinq.Data.Linq.Implementation.QueryProvider`1.Execute[TResult](Expression
>> expression) in
>> d:\dev\work\colaboration\dblinq\DbLinq\Data\Linq\Implementation\QueryProvider.cs:line
>> 110
>> at System.Linq.Queryable.Count[TSource](IQueryable`1 source)
>> at DbLinqTest.Program.Main(String[] args) in
>> H:\DbLinqTest\Program.cs:line 40
>>
>> The engine fails on writing the "SELECT" part of sql expression.
>>
>> I'm using sqlite provider and head version from svn.
>>
>> A test is attached.
>>
>> Tony
>>
>> >>
>>
>
>
> --
> Pascal.
>
> jabber/gtalk: [EMAIL PROTECTED]
> msn: [EMAIL PROTECTED]
>
--
Pascal.
jabber/gtalk: [EMAIL PROTECTED]
msn: [EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
