need help with embedded database and C#

Hello Ruwald,

You have several options of lightweight SQL/NOSQL options that you can use with C# on a machine with limited install rights:

· SQLlite: SQLlite is supporting many features of t-sql.

· RavenDB

· SQL Server Compact Edition

"SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine."

Should be pretty simple to set up and get working and you probably wont need to install anything. There is an ADO.NET adapter which you can get from here:

http://system.data.sqlite.org

Using SQLlite in C# application : http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application

Hope you are looking for this.

Other links:

http://social.msdn.microsoft.com/Forums/vstudio/en-US/08b2a425-0ccb-4b4d-b2bf-32c1488f0543/a-database-self-contained-within-my-c-application

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dhirendra Misra12y ago
Accepted answer
Hello Ruwald,

You have several options of lightweight SQL/NOSQL options that you can use with C# on a machine with limited install rights:

·                  SQLlite: SQLlite is supporting many features of t-sql.

·                  RavenDB

·                  SQL Server Compact Edition
"SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine."
Should be pretty simple to set up and get working and you probably wont need to install anything. There is an ADO.NET adapter which you can get from here:
http://system.data.sqlite.org
Using SQLlite in C# application : http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application
Hope you are looking for this.

Other links:
http://social.msdn.microsoft.com/Forums/vstudio/en-US/08b2a425-0ccb-4b4d-b2bf-32c1488f0543/a-database-self-contained-within-my-c-application
Ruwald Lichtenstein12y ago
thanks