If I am not going to save data to an SQL database, where should I save it?

Question

I am making an encyclopedia program similar to RAWR for World of Warcraft. I am not going to save data from an SQL database, but I was so diligent that I always did it when I am sure that there are alternatives for these easier cases of use.

For example, my program will not create new data through user input and delete data through user input. Just a program that will display the information that I encode into it. Nothing more, nothing less.

Where should I save these things? By keeping, I mean, keep them for deployment when you release the program.

Basically I am going to save only string variables and some videos / animations ( see my other question )

Thanks for the help. As always, you guys rock!

Answer 1

What happened to the old old file system?

You simply create a subfolder under your application folder and in your code always refer to the files in this subfolder using the path to the application folder. eg.

string imagePath=Path.Combine(Environment.CurrentDirectory,"SubFolderName\\picture.jpg");

I used SQLite myself and love it, but even this may be redundant for your needs, since you are not saying that you need to perform many operations with queries.

, , SQL Server/SQLite, . , , , .

, , , .., .

, , .

- Assembly. dll, . , , .

Answer 2

? , / , . , , , SQL-?

System.Data.Sqlite, , . , , . , RAD Visual Studio .

Answer 3

, . . , . , , , XML Linq XML . XDocument.

, , . - SubSonic SimpleRepository, SQLite. , , , DB4O!

Answer 4

xml,

Answer 5

- XML () , Mark Ewer yetapb. SQLLite .

- Excel OleDb. SQL . Excel, , , , : 1) , ( , SQL + ). 2) , OleDb, , . , , .

I'm sure there are some other minor quirks that need to be overcome when playing with Excel from .NET, but I only did this in the real world twice (although a lot of data was involved at the same time). I would definitely not recommend it for a corporate environment.

I would suggest storing media on your file system, depending on how you go. Then simply enter the data, regardless of whether it is in SQL, Excel, XML or binary code file name. This will simplify data management.