Schema specified is not valid. error.

Question

1.00/5 (1 vote)

See more:

link to view Erros

As per picture mentioned error during access Entity Framework tables in data source. I've built the Microsoft.AspNet.Providers -version 1.2 (build under EntityFramework 5.0) 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.

What I have tried:

I've tried to recompile after insert those "Application,Role,User,Profile,Memebership" tables into edmx (after delete and build a new one).

Posted 7-Mar-16 15:34pm

koklimabc

Updated 7-Mar-16 20:16pm

v5

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wonde Tadesse · Accepted Answer · 2016-03-07T15:50:00

Solution 1

See this SO answer.Entity framework - EF is throwing an error. Schema specified is not valid [^]

Posted 7-Mar-16 15:50pm

Wonde Tadesse

Maciej Los · Accepted Answer · 2016-03-07T20:16:00

Well... hard to guess till the definition of database model is unknown.

In general, there can be - at least - few possible reasons of this error:

Enum is not supported in EF 5.0 for .NET 4.0. This feature is available for EF 5 in .NET 4.5
Model Checker fails to check the current Database state with my EF model
A [Key] attribute for one of class is not defined
etc.

I'd suggest to read the Entity Framework (EF) Documentation[^] to resolve this error, especially the parts:

EDMX files[^]
Relationships and Navigation Properties[^]

Entity Framework Relationships - EF Designer[^]

Entity Framework Code First Data Annotations[^]
Entity Framework Fluent API - Relationships[^]

Good luck!