need help with embedded database and C#

Question

hey guys  i need help im trying to create a stand alone applications that suppose to run on varoius different pc but it is database driven so i need the followoing 1)a database that can run inside my app 2) one that allows sql features like views store procedures tables ect 3) one that doesnt require the installation of lets say sql server on users pc hope you guys can help im stuck thanks in advanced ps have been using sql server to test on my machine

Dhirendra Misra · 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 Lichtenstein · Answer

thanks