tag:blogger.com,1999:blog-5238131531249720750.post8528552913240065250..comments2024-03-19T13:28:26.291+01:00Comments on Everything SQL Server Compact: Getting started with SQLite in Windows Store / WinRT appsErikEJhttp://www.blogger.com/profile/12641272161018114573noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-5238131531249720750.post-66492374752832591342016-04-02T13:26:00.885+02:002016-04-02T13:26:00.885+02:00http://stackoverflow.com/questions/36361731/how-ca...http://stackoverflow.com/questions/36361731/how-can-i-use-the-database-that-i-already-have-got-with-entity7-in-uwpS.Rhttps://www.blogger.com/profile/01834264456813649354noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-22809174127774564522016-04-02T13:17:23.619+02:002016-04-02T13:17:23.619+02:00S.R: Yes it is, but not is blog comments - please ...S.R: Yes it is, but not is blog comments - please ask on Stackoveflow or similarErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-15009867101898473722016-04-02T12:52:50.348+02:002016-04-02T12:52:50.348+02:00It is possible to explain with an example.
I'm...It is possible to explain with an example.<br />I'm really confused and need help :(S.Rhttps://www.blogger.com/profile/01834264456813649354noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-14305975308392912142016-04-02T12:07:23.498+02:002016-04-02T12:07:23.498+02:00S.R: I beleiv you can use scaffolding: http://ef.r...S.R: I beleiv you can use scaffolding: http://ef.readthedocs.org/en/latest/cli/powershell.html#scaffold-dbcontext ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-35967064965975475412016-04-02T10:35:16.193+02:002016-04-02T10:35:16.193+02:00I have always seen that in all tutorials, database...I have always seen that in all tutorials, databases are made in the form of code-first, but already there is a sqlite database that I want to use in my project. And I want to use entity 7 too. To do so, I made some classes from my database by means of a dll but it didn't work. In fact, I made these classes so that I could use my own database. I didn't want it to create a new database. Any suggestions?S.Rhttps://www.blogger.com/profile/01834264456813649354noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-57738191777028748972014-10-15T13:14:37.238+02:002014-10-15T13:14:37.238+02:00Unknown: the sqlite connection is not thread safe,...Unknown: the sqlite connection is not thread safe, that is all I knowErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-51337234537569459802014-10-15T12:21:27.342+02:002014-10-15T12:21:27.342+02:00Hi! Your code is very helpful. I like to ask some ...Hi! Your code is very helpful. I like to ask some out topic question. What is best practice for the database connection? I am thinking of maintaining one and open SQLiteConnection object since Store apps are not multi-user.Unknownhttps://www.blogger.com/profile/05099681797895415460noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-56709855749735511692014-03-08T08:46:49.449+01:002014-03-08T08:46:49.449+01:00Ankit: suggest you ask in a forum, and provide mor...Ankit: suggest you ask in a forum, and provide more info, for example some codeErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-63925154994404488032014-03-08T07:34:02.059+01:002014-03-08T07:34:02.059+01:00hi there i made an app package but when i install ...hi there i made an app package but when i install it using power shell it make database with 0kb and without any table and data what is the problem. i take database as content and make copy always option enable. Anonymoushttps://www.blogger.com/profile/13400706597159039850noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-40828003119198849552014-01-28T06:54:14.952+01:002014-01-28T06:54:14.952+01:00Thanks Erik for the url,
I got it solved in a sim...Thanks Erik for the url,<br /><br />I got it solved in a similar way as https://sqlwinrt.codeplex.com/.<br /><br />Like you have mentioned in your article first i pasted my db in the project folder. Then in the db file properties set it to copy always.<br /><br />Then i used the following code:-<br /><br />var dbPath = Windows.ApplicationModel.Package.current.installedLocation.path + '\\mydb.db';<br /><br />It worked!<br />Anonymoushttps://www.blogger.com/profile/12572239897531225028noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-66061439880420920172014-01-27T11:25:04.667+01:002014-01-27T11:25:04.667+01:00Sibin: No, I do not, I think you will have to use...Sibin: No, I do not, I think you will have to use soemthing like: https://sqlwinrt.codeplex.com/ but not sure.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-26048633815501563742014-01-27T07:16:41.100+01:002014-01-27T07:16:41.100+01:00Hi ErikEJ,
Thanks for the excellent article!
Wo...Hi ErikEJ,<br /><br />Thanks for the excellent article! <br /><br />Would you please tell me how to use an already existing sqlite database(like Chinook.db) in windows 8.1 RT app using WinJS/Javascript and HTML instead of C#?Do you have any sample code or tutorial?Anonymoushttps://www.blogger.com/profile/12572239897531225028noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-43683569150667034782012-12-10T19:03:16.122+01:002012-12-10T19:03:16.122+01:00Hi Anthony: Thanks for the useful information, may...Hi Anthony: Thanks for the useful information, maybe you should report this at the sqlite-net project on githubErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-63050413054837885802012-12-10T16:26:47.361+01:002012-12-10T16:26:47.361+01:00Hi Erik,
Stumbled across a bug today to do with U...Hi Erik, <br />Stumbled across a bug today to do with Unicode characters in user names causing databases to fail.<br /><br />I've been bit by the Irish problem as I call it before, after a customer named O'Casey (name changed obviously) caused problems because of his user name.<br /><br /> Well, there seem to have been some problems here: <br />http://social.msdn.microsoft.com/Forums/en-AU/winappswithcsharp/thread/875fc167-b8c4-4d45-a74d-67e311d3c436 <br /> to do with Unicode, so I tried to create my SQLite database with this filename:<br /><br /> "⛇.db"<br /><br /> (yes that's a snowman!)<br /><br /> Well, needless to say, it doesn't work. So if your user has a name with Unicode characters (or snowmen) in it, you're in for app failure!<br /><br /> My cure was to modify SqlLiteConnection in SQLite.cs as follows:<br /><br /> // var r = SQLite3.Open (DatabasePath, out handle); <br /> var utf8 = new UTF8Encoding(); <br /> var r = SQLite3.Open(utf8.GetBytes(DatabasePath), out handle, (int)(SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.Create), Sqlite3Statement.Zero);<br /><br /> This forces the database open with a UTF8 filename, and processes the database as UTF-8.<br /><br /> You can also use Open16, but that I believe opens the file in UTF16.A Wieserhttps://www.blogger.com/profile/10113336609848585467noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-51357444671493639812012-08-24T07:48:25.172+02:002012-08-24T07:48:25.172+02:00Thanks, Jerry. Well, this initial article mainly d...Thanks, Jerry. Well, this initial article mainly deals with local reference data. It sounds like your questions are topics for other blog posts, but for backup, a feature like Copy to SkyDrive comes to mind, and one could do inserts to a separate database file, and implement a synchronize mechanism, that clear the local inserted rows when done. Updates and deletes are more compilcated, but in many scenarios less common.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-48868911311921804692012-08-23T15:33:01.427+02:002012-08-23T15:33:01.427+02:00Excellent article! Now, do you save dual places (l...Excellent article! Now, do you save dual places (local and cloud or roam)? And, what's your strategy to keeping them in sync if you fall offline? //Jerryjerrynixonhttps://www.blogger.com/profile/06978720385628364065noreply@blogger.com