Database without server in C #

Question

Fill out a new question here: I am just playing C # for the first time and want to make a Windows Forms application that stores some information in the database structure, but obviously does not want to require MySQL to be installed on each client computer. How can I do it?

Answer 1

You are using a database that does not require installation. There are several - there is Microsoft SQL Server Compact , which, frankly, is poorly named because it will not support more useful SQL functions, such as stored procedures, views, etc. There's also VistaDB , which supports saved procs, but requires a purchase if you want Visual Studio plugins.

Answer 2

You can use SQLite . It does not require installation or a server on client computers. Here is the System.Data.SQLite Blog

: "SQLite - , , , , SQL. SQLite SQL . SQLite ."

Answer 3

- . , :

:

• VistaDB - #.

:

• Firebird - .NET
• SQLite - .NET

Answer 4

SQL Server CE

Answer 5

XML, Sql Server Compact Edition.

/ .

, , ( ).

Answer 6

.NET 3.5 XML Linq to XML. SQL- , , IDE IntelliSense .

Answer 7

, XML. , , , MySQL . SQL Express, , , ?

Serialise Dataset:

http://blogs.msdn.com/yosit/archive/2003/07/10/9921.aspx http://msdn.microsoft.com/en-us/magazine/cc163911.aspx

Answer 8

- SQL Server Compact, Visual Studio ( , VS). " ", Table Adapter , , . "DS", Table Adapter

DSTableAdapters 

GetData() Fill() Insert(), Update() Delete() .

Answer 9

VelocityDB operates in a smaller server mode, but can also be integrated with the server when necessary. It surpasses all other options mentioned here by approximately the size, see the comparison here . This allows you to constantly use almost any .NET data structure. The entire database engine and additional server are implemented using C # code.