Specified method is not supported - ExecuteSqlCommand

May 29, 2013 at 9:52 AM
Is this possible using Effort?

db.Database.ExecuteSqlCommand(mySql);
Coordinator
May 29, 2013 at 10:12 AM
Edited May 29, 2013 at 10:13 AM
Hello,

Unfortunately it is not. Check the FAQ
Does it have any limitation?

Yes, it can only emulate operations that go through the Entity Framework pipeline. This follows that database specific operations cannot work (e.g: ExecuteStoreCommand). Stored procedures, views and triggers cannot be emulated too.