如何使用MS Access作为ADO.NET实体框架的提供程序？

  <add name="AccessConnectionString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\path\to\your\database.accdb;Persist Security Info=False;" />
</connectionStrings>

 <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework">
   <parameters>
     <parameter value="Data Source=C:\path\to\your\database.accdb;Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;" />
    </parameters>
  </defaultConnectionFactory>
  <providers>
   <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
   <provider invariantName="System.Data.OleDb" type="System.Data.Entity.OleDb.OleDbProviderServices, EntityFramework.SqlServer" />
  </providers>
</entityFramework>

using (var context = new YourDbContext())
{
    var query = from item in context.YourTable
                where item.SomeColumn == "SomeValue"
                select item;

    foreach (var item in query)
    {
        Console.WriteLine(item.SomeColumn);
    }
}