Click here to Skip to main content
15,890,399 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more: , +
SQL
Schema specified is not valid. Errors:
LaxmiTatkalEntity.msl(630,12) : error 2019: Member Mapping specified is not valid. The type 'Edm.String[Nullable=False,DefaultValue=,MaxLength=10,Unicode=False,FixedLength=False]' of member 'TotalAmount' in type 'DBLaxmiTatkalModel.TblChallan' is not compatible with 'SqlServer.int[Nullable=False,DefaultValue=]' of member 'TotalAmount' in type 'DBLaxmiTatkalModel.Store.TblChallan'.

XML
Line 230:        public List<TblEmployeeRegistration> getallemployeeId()
Line 231:        {
Line 232:            var data = (from m in objentity.TblEmployeeRegistrations
Line 233:
Line 234:                        select m).ToList();
Posted
Updated 22-Jun-18 20:04pm
v2
Comments
Er Daljeet Singh 23-Apr-14 6:24am    
check your database column and the entities you had created.
there name should be same otherwise go to Model Browser window and check the mapping there.
Herman<T>.Instance 23-Apr-14 7:07am    
indeed!

1 solution

In your database table you change the  datatype of TotalAmount.
now update your model.edmx model in visual studio
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900