Keyword not supported data source initializing Entity Framework Context

Question

I m initializing Entity Framework Object context  and this gives me the keyword not supported error   metadata res     MainDB csdl res     MainDB ssdl res     MainDB msl provider System Data SqlClient provider connection string  amp quot Data Source   SQLEXPRESS AttachDbFilename D  Workspace vs Leftouch Leftouch Web Data Leftouch mdf Integrated Security True Connect Timeout 30 User Instance True App EntityFramework amp quot   I took the connection string directly from web config which was working  and modified only the path to the file  which I set dynamically   and instead of using the default value  used this connection string explicitly  What could cause this error

User · Accepted Answer

The real reason you were getting this error is because of the " values in your connection string.

If you replace those with single quotes then it will work fine.

https://docs.microsoft.com/archive/blogs/rickandy/explicit-connection-string-for-ef

(Posted so others can get the fix faster than I did.)

User · Answer

Make sure you have Data Source and not DataSource in your connection string  The space is important  Trust me  I m an idiot

User · Answer

I fixed this by changing EntityClient back to SqlClient  even though I was using Entity Framework   So my complete connection string was in the format    lt add name  DefaultConnection  connectionString  Data Source localhost Initial Catalog xxx Persist Security Info True User ID xxx Password xxx  providerName  System Data SqlClient    gt

User · Answer

This appears to be missing the providerName  System Data EntityClient  bit  Sure you got the whole thing

User · Answer

Believe it or not  renaming LinqPad exe config to LinqPad config solved this problem

User · Answer

Just use    instead  quot   it should resolve the issue

[entity-framework] Keyword not supported: "data source" initializing Entity Framework Context

Examples related to entity-framework

Examples related to connection-string