Schema specified is not valid. Error.

KokLim Tan

10y8.7k.NET

http://s20.postimg.org/f9xdevxb1/Errors.jpg

As per picture mentioned error (Error in above link) during access Entity Framework tables in data source. I've built the Microsoft.AspNet.Providers -version 1.2 from nuget console and try insert tables "Application,Role,User,Profile,Memebership" along with their inter relationship linking in keys. I've done with rebuild but still same error.

Could someone else who already know how to fix the problem and guide me to fixit in ASAP.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

KokLim Tan10y ago
Dear Rajeev,

Thanks for your reply, I've found my solution by not include "Applications" tables when "update model from database" in my edmx. It seems to have problem for foreign keys linking from "Application Tables" to other three tables "membership,user and role".

Why the "Applications" Tables had such problem when include into entityframe work model tables?

KLTAN
Rajeev Punhani10y ago
Hi Tan,
This means that the application is unable to load the EDMX. There are several things which can cause this.
- You might have changed the MetadataArtifactProcessing property of the model to Copy to Output Directory.
- The connection string could be wrong. I know you say you haven't changed it, but if you have changed other things (say, the name of an assembly), it could still be wrong.
- You might be using a post-compile task to embed the EDMX in the assembly, which is no longer working for some reason.
If the above solution is helpful then,accept the answer.