I have Windows 7 x64, Visual Studio 2012 with the 'ODAC 11.2 Release 5 and Oracle Developer Tools for Visual Studio (11.2.0.3.20)'. Then I connected to Oracle db, create .edmx model. But when I'm trying to use EF to operate some data
var ent = new Entities();
var res = ent.table1.ToList();
Error happends
Schema specified is not valid. Errors:
Model.ssdl(2,2) : error 0152: No Entity Framework provider found for
'Oracle.DataAccess.Client' ADO.NET provider. Make sure the provider is registered in
the 'entityFramework' section of the application config file. See
http://go.microsoft.com/fwlink/?LinkId=260882 for more information.
I checked my AppConfig, all sections are ok. Also I installed ODAC1120320Xcopy_x64 (and added a environment variables too). But nothing changes.
If I do it in this way, all works fine
EntityConnection econn = new EntityConnection("name=Entities");
econn.Open();
EntityCommand ecmd = econn.CreateCommand();
ecmd.CommandText = "SELECT e.NAME FROM Entities.table1 as e";
EntityDataReader ereader = ecmd.ExecuteReader(CommandBehavior.SequentialAccess);
while (ereader.Read()) { ... }
Have you any ideas? Will be very grateful for any help.