Problem with MS Mobile local database

Question

My problem is basically the same as in the post below, but on Windows Mobile 6:

In short: I need a local database accompanying the executable, and I'm trying to do that using the CE database. In the first reply under the post above there is a solution, though it doesn't work on Mobile, i.e. this line can't compile:

string dbfile = new System.IO.FileInfo(System.Reflection.Assembly.GetExecutingAssembly().Location).DirectoryName + "\\datafile.sdf";

And that's due to lack of the "Location" attribute.

What's the solution? I'm quite new to databases on .Net, and documentation on MSDN is too vague for me to help.

Ganesan · Accepted Answer · 2011-08-23 03:34:05Z

0

SQLite is the best solution for your problem statement. Itz a self-contained, serverless, zero-configuration, transactional SQL open source database engine. It occupies few KB; but manages the storage upto 2GB. Nokia is SQLite Consortium member. I tried in one of the tool developement; itz powerful. Get more info at http://www.sqlite.org/

answered Aug 23, 2011 at 3:34

Ganesan

735 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

King · Accepted Answer · 2011-08-23 15:53:01Z

0

SQL CE should be fine. I am a bit confused on whether you are refering to on the mobile device or on a computer because you mention "it doesn't work on Mobile", and indeed the compact framework doesn't support the call to location. Some clarification on what you are specifically trying to do would help.

On the mobile device try

System.IO.Path.GetDirectoryName( 
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);

To get the folder path.

answered Aug 23, 2011 at 15:53

King

3391 silver badge5 bronze badges

Collectives™ on Stack Overflow

Problem with MS Mobile local database

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related