How can I use MS Access as a provider for ADO.NET entity framework ?

Question

Hi, Do you know to use a provider for MS Access in ADO.NET Entity Framework?

Answer 1

ADO.NET Entity Framework is designed to work with anything that as standard ADO.NET provider. Access does.

Answer 2

I don't know if this will help you, but take it for what it is worth. Following is my connection string in C# to connect to a MS-Access database.

I have a strongly typed dataset that I put the data into and them manipulate it there. Use the System.Data.OleDb namespace.

sourceString = "\\\DatabaseServer\DatabaseFolder\database.mdb";

conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sourceString;
string strSql1 = "SELECT * FROM IDTable";
OleDbConnection con = new OleDbConnection(conString);

currentDataSet.IDTable.Rows.Clear();
con.Open();
OleDbDataAdapter dAdapter = new OleDbDataAdapter();
dAdapter.SelectCommand = new OleDbCommand(strSql1, con);
dAdapter.Fill(currentDataSet, "IDTable");
con.Close();