Does C# have some kind of it's own clientside database implemention

Does C# have it's own kind of database system like Access/ADO alternative.

I would like to make sure it's in the .NET framework no external libr开发者_开发问答aries.

If no which one would you recommend I should use for a compact, small and lightweight database.

It does not, C# is just the language. The .NET framework does not directly either.

SQL Server Express is one option (though probably not lightweight enough): http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

SQL Server CE is better: http://www.microsoft.com/sqlserver/en/us/editions/compact.aspx

...as is SQLlite for .NET: http://sqlite.phxsoftware.com/

If you don't need relational features at all and the data is small enough, you could use XML storage directly.

A combination of Entity Framework and MS SQL Server Compact that ships with Windows 7 and is a free database engine is an ideal, almost "embedded" into .Net data solution for your purpose.

You may like to take a looks at Jet Blue/ESENT which is a transactional, indexable ISAM database engine thats shipped with every version of windows since win2k. There are C#/LINQ bindings here.

I think C# and MS-SQL Server makes the ideal pair for most of the solutions. But if you are looking for cheaper solution you can choose MySQL.

SQLite is a popular choice for small-footprint lightweight minimally invasive installations and there's a robust data provider for .NET.