Browse by Tags

version upgrade to 1.0.65.0 : invalidcastexception

Hi, I have just upgraded to 1.0.65.0, and I am getting the error: InvalidCastException: Unable to cast object of type 'System.Data.SQLite.SQLiteConnection' to type 'System.Data.SQLite.SQLiteConnection'. at System.Data.SQLite.SQLiteCommand.set_DbConnection(DbConnection value) The error...

Posted to Entity Framework (Forum) by NGarg on 01-27-2010
EF and/or LINQ for Compact Framework

Hello, EF and/or LINQ is supported for Compact Framework? Is there a sample for it? Thanks, Zoltan

Posted to Entity Framework (Forum) by korbai on 06-26-2009
Get "cannot rollback - no transaction active" when trying to use a context on which there was a failure

Hi, First off: Thanks for doing this and making it available for free. I appreciate it. I get a failure when I try to execute context.SaveChanges() (using Entity Framework) A little bit of background: I create a database connect to it via entity framework and sqlite ado.net provider. I cause a failure...

Posted to Entity Framework (Forum) by pwab on 06-25-2009
Re: How to use a relative database path in the connectionString

The following works fine for SQLite (for Sql Server I have not tested) : public static string GetEntityConnection() { string metadata; // Initialize the connection string builder for the underlying provider. SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder(); //Specific to Sql Server...

Posted to Entity Framework (Forum) by skneife on 03-11-2009
Re: Project using EF... Installation does not work

Hi there! First of all, I'd like to say thanks for the great work on System.Data.SQLite! I have the same problem as Amol has. On local machine, the app runs fine. On any other pc (Where I installed the app via setup project), I get an error message about the not found provider (not present or not...

Posted to Entity Framework (Forum) by crazymc on 11-06-2008
sub-optimal SQL generated for Skip(n)

The Skip(n) method is not optimally transformed into SQL. Consider the following LINQ expression: (from e in _context.EMPLOYEE orderby e.NAME select e.NAME).Skip(9999).Take(99); This generates the following SQL: SELECT [Var_8_1].[NAME] AS [NAME] WHERE NOT (EXISTS (SELECT [Var_8_3].[NAME] AS [NAME] FROM...

Posted to Entity Framework (Forum) by peter77 on 10-17-2008
testlinq does not work on test env (dev. it works jusst fine)

On my development system (which is English) the testlinq application (from the source of SQLite) works perfectly. Also the application I developed works just fine. When installing testlinq on a test machine (Windows XP SP2, DOTNET 3.5 SP1, DUTCH!!) it fails (DBFactory problem). I have tried to install...

Posted to Entity Framework (Forum) by mtimmerm on 10-09-2008
How to acquire the ID of last row inserted using Entity Framework?

Hi there, Does anyone happen to know if there is a way in the Entity Framework to return me the ID of a just inserted row, assume the column is an integer type and is Identity column? This feature should be similar to scope_identity() in T-SQL, or last_rows_affected() for Sqlite. But since I'm not...

Posted to Entity Framework (Forum) by ray247 on 09-30-2008
Optimized linq queries

Hi Robert, I use a set of linq queries (linq to entities RTM) to get data from a database containing music information (http://www.luminescence-software.org/download/MetatOGGer-270808.exe) : // exact search, case sensitive from album in entities.AlbumJeu.Include("Artist") from track in entities...

Posted to Entity Framework (Forum) by Cyber Sinh on 09-01-2008
[Entity Framework] Cannot commit transaction

Hi, I have a pretty annoying problem when using transactions with the entityframework... In my application, I'm using transactions as follows : - when I connect to the database, I immediately begin a transaction - when the user clicks "save", I commit the transaction and begin a new one...

Posted to Entity Framework (Forum) by Thomas Levesque on 08-31-2008

Page 1 of 2 (15 items) 1 2 Next >