Re: [sqlite] Having problems with Entity Framework code first db creation
I have uploaded a project to http://www.sawtoothsoftware.com/download/temp/SQLiteTest.zip. It contains the VS 2013 example. Walter Williams Senior Software Engineer Sawtooth Software, Inc. "Do, or do not. There is no try." -Original Message- Thank you for the chuckle. As to the actual question, when you say "when I try to create a new database file", do you mean that you are using the open command (or whatever in the wrapper tries to call the sqlite3_open* commands) with a valid filename (which need not exist, but must be a valid name) and then it fails with the mentioned message? The list unfortunately (or fortunately) does not permit attachments, could you use a file upload/sharing service kindly so we can access the file and (hopefully) better understand the question? - thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Having problems with Entity Framework code first db creation
This sounds like a problem with the connection string being passed to SQLiteConnection. Your attached package didn't come through, so could you send the connection string you're using? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Walter Williams Sent: Friday, January 23, 2015 6:52 AM To: sqlite-users@sqlite.org Subject: [sqlite] Having problems with Entity Framework code first db creation I'm trying to use a code first model using the System.Data.SQlite NuGet (v1.0.94.1) package and Entity Framework. I'm using VS 2013. I have defined my objects, but when I try to create a new database file using them, I get an error "Unable to complete operation. The supplied SqlConnection does not specify an initial catalog or AttachDBFileName." The attached project has a sample of the code which demonstrates the error. For size the packages folder is not included. I was able to use the same code with SQL Server Compact 4.0 but for preference I'd like to use SQLite. Is this a bug in the package or am I missing something? Walter Williams Senior Software Engineer Sawtooth Software, Inc. "Do, or do not. There is no try." ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Having problems with Entity Framework code first db creation
On 2015/01/23 16:51, Walter Williams wrote: I'm trying to use a code first model ///... (snipped) then in the signature... "Do, or do not. There is no try." Thank you for the chuckle. As to the actual question, when you say "when I try to create a new database file", do you mean that you are using the open command (or whatever in the wrapper tries to call the sqlite3_open* commands) with a valid filename (which need not exist, but must be a valid name) and then it fails with the mentioned message? The list unfortunately (or fortunately) does not permit attachments, could you use a file upload/sharing service kindly so we can access the file and (hopefully) better understand the question? - thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Having problems with Entity Framework code first db creation
I'm trying to use a code first model using the System.Data.SQlite NuGet (v1.0.94.1) package and Entity Framework. I'm using VS 2013. I have defined my objects, but when I try to create a new database file using them, I get an error "Unable to complete operation. The supplied SqlConnection does not specify an initial catalog or AttachDBFileName." The attached project has a sample of the code which demonstrates the error. For size the packages folder is not included. I was able to use the same code with SQL Server Compact 4.0 but for preference I'd like to use SQLite. Is this a bug in the package or am I missing something? Walter Williams Senior Software Engineer Sawtooth Software, Inc. "Do, or do not. There is no try." ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users