Cannot evaluate the exception stack trace

sonal malhotra

hi,

System.Data.Entity.ModelConfiguration.ModelValidationException

HResult=0x80131500

Message=One or more validation errors were detected during model generation:

SetupCurriculumTemplateCourse_Course_Source: : Multiplicity is not valid in Role 'SetupCurriculumTemplateCourse_Course_Source' in relationship 'SetupCurriculumTemplateCourse_Course'. Because the Dependent Role properties are not the key properties, the upper bound of the multiplicity of the Dependent Role must be '*'.

Source=

StackTrace:

it is data annotation error .. please fix

8 Replies

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

Sachin Singh5y ago
Accepted answer
The error is speaking boldly that you are trying something on 1to1 relationship , i will suggest you to use Fluent Api instead of data annotation to achieve 1to 1 relationship in EF code first.

Yet if you like Data Annotation techinque more then here i can give you an example
public class Class1
{
    public int Id {get;set;}
    [Required]
    public virtual Class2 Class2 {get;set;}
}

public class Class2
{
    [Key, ForeignKey("Class1")]
    public int Id {get;set;}
    [Required]
    public virtual Class1 Class1 {get;set;}
}
Hope you understand what i have suggested.Let me know.
sonal malhotra5y ago
System.Data.Entity.Core.EntityCommandExecutionException
HResult=0x8013193C
Message=An error occurred while executing the command definition. See the inner exception for details.
Source=
StackTrace:
Inner Exception 1:
SqlException: Invalid column name 'SetupCurriculumTemplate_CurriculumTemplateId'.
Invalid column name 'SetupCurriculumTemplate_CurriculumTemplateId'.

which column Name?
sonal malhotra5y ago
i could not abe to do fluent api ..
sonal malhotra5y ago
ok .... after that i have to put in console -- update Database right? ...
Sachin Singh5y ago
idk which class has dependency on which class in your project , i just can give you an idea of 1 to 1 with fluent API
i am taking example of course has cover , cover doesn't need course

Go to Your DbContext class and override OnModelCreating like below.
protected override void OnModelCreating(DbModelBuilder modelBuilder)
       {
modelBuilder.Entity
   .HasRequired(c
   =>
   c.Cover)
   .WithRequiredPrincipal(c
   =>
   c.Course);
OR///////
   modelBuilder.Entity
   .HasRequired(c
   =>
   c.Course)
   .WithRequiredDependent(c
   =>
   c.Cover);

}
sonal malhotra5y ago
hi
yes u correct
Sachin Singh

,,there r many classes in my project ..

1 . course class
2. SetupCurriculumTemplateCourse
3.curricurul template class ..

i cant understand how to ddo multiple use Fluent Api ..can u fix my prject?
sonal malhotra5y ago
.. it does not work
Mageshwaran R5y ago
Hi sonal,
please refer this link,it may help you:
https://stackoverflow.com/questions/36405897/an-exception-of-type-system-data-entity-modelconfiguration-modelvalidationexcep

Cannot evaluate the exception stack trace

Sachin Singh