in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

LINQ EF: Variable Assinging using firstordefault fails

Last post 08-25-2008 8:32 AM by Robert Simpson. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 08-25-2008 5:22 AM

    LINQ EF: Variable Assinging using firstordefault fails

    Hi,

    I add this to the program.cs TestLinq project.

    this fails: 

    string scity = "London";
    Customers cdata = db.Customers.FirstOrDefault(cd => cd.City == scity);

    {"SQLite error\r\nnear \"1\": syntax error"}.

     This is working:

    Customers cdata = db.Customers.FirstOrDefault(cd => cd.City == "London");

     

    Marcel

    Filed under:
  • 08-25-2008 7:45 AM In reply to

    Re: LINQ EF: Variable Assinging using firstordefault fails

    Gotta love mondays.

     

  • 08-25-2008 7:49 AM In reply to

    Re: LINQ EF: Variable Assinging using firstordefault fails

    Yes, indeed. I started this morning with some errors :)  If you want me to do some more test please let me know...

    Filed under:
  • 08-25-2008 8:32 AM In reply to

    Re: LINQ EF: Variable Assinging using firstordefault fails

    Ok -- this one is fixed in the pending 57 release.  Dr. Hipp appears very close to releasing an update engine with several of my LINQ bugfixes, so I'm trying my best to hold off until he posts the next SQLite revision.

    Either way, I'll release this week -- with or without the new engine.

Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems