Read and write to Access DB with C#

Question

I am making a very basic program for a friend of mine that will need a very basic DataBase. I will have about 3 tables at max, I was wondering if it is possible to use access database files easily in C# just like a normal SQL database and if so how? I have seen some tutorials using OLEDB but none really give me a clear way to do things.

Answer 1

It doesn't really go with the Access need but i throw this answer based on the OPs' intention to digg into SQLite.

So i would go for SQLite for its simplicity and efficiency.

See these posts on a very fast and easy way to work with SQLite and Entity Framework:

• GETTING STARTED, USING SQLITE WITH .NET

• USING SQLITE WITH ENTITY FRAMEWORK 6 AND THE REPOSITORY PATTERN

• SQLITE WITH ENTITY FRAMEWORK CODE FIRST AND MIGRATION

• Entity Framework 5 on SQLite

• Portable databases (II): using SQLite with Entity Framework