SQL single file database

[xg3]

Hi everyone,

Wondering if there is such a thing as a single file SQL database i can use for my C# applications. Normally I would whack a copy of SQL Express on a machine for my own stuff, but thats way to chunky for distribution to the public.

So if anyone has any ideas, id love to hear them, and whilst I could use a Access Database file, access is crap and i'd rather not :D

Thanks


Xavier

[davef]

No. In SQL Server, any database comprises of at least two files: Data file (*.mdf) and Log file (*.ldf).
Refer to the primer below:
A primer on SQL Server database files

[azimmer]

Hi everyone,

Wondering if there is such a thing as a single file SQL database i can use for my C# applications. Normally I would whack a copy of SQL Express on a machine for my own stuff, but thats way to chunky for distribution to the public.

So if anyone has any ideas, id love to hear them, and whilst I could use a Access Database file, access is crap and i'd rather not :D

Thanks


Xavier

Take a look at SQLite (www.sqlite.org ); it's really good. I've used it several times from TCL and C; I don't know how it aligns with C#, though.