Hi. I'm writing a .NET / C# desktop application and want to have a database in the program. However, when I deploy my project, I don't want users to see MDF files, XSD files, or anything like that, which I believe they will if I were to insert datasets or similar things into my program. I suppose, XML files would be alright if they are in the app's directory or a user settings (like "local settings/<my app>") type of directory. What is the best way to accomplish this in .NET? I would like to be able to query the database via SQL or LINQ statements (preferrably LINQ, but SQL is good too). Also, I would like the solution to be minimal - easy setup, easy access to the data (singleton instance of the db or something like: AppDB db = new AppDB; var info = select a from info.mytable ..... ;
Question
ProChefChad
Hi. I'm writing a .NET / C# desktop application and want to have a database in the program. However, when I deploy my project, I don't want users to see MDF files, XSD files, or anything like that, which I believe they will if I were to insert datasets or similar things into my program. I suppose, XML files would be alright if they are in the app's directory or a user settings (like "local settings/<my app>") type of directory. What is the best way to accomplish this in .NET? I would like to be able to query the database via SQL or LINQ statements (preferrably LINQ, but SQL is good too). Also, I would like the solution to be minimal - easy setup, easy access to the data (singleton instance of the db or something like: AppDB db = new AppDB; var info = select a from info.mytable ..... ;
Link to comment
Share on other sites
12 answers to this question
Recommended Posts