Hi
On my local machine my website runs perfectly, but not on the remote server (it was working initially, until I probably did a "bad" change, but cannot remember what)....
Now I get on the remote server the following error:
Schema specified is not valid. Errors:
App_Code.myentity.csdl(620,10) : error 0005: Data at the root level is invalid.
I copied again the files in the app_code folder and checked the connection strings for the myentity and other connections in the web.config file on the remote site, which are fine (I get data in the grid views without problem).
Any suggestions?
Thanks.

Hi there,

Looks like your EF EDMX model is broken somehow. Did you try updating or recreating it?

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

I updated it several times, without success. How do I delete an entity model?

Deleted it, I'm building it again....

I recreated the entity from scratch. It's working perfect on my local machine. I copied the files to the remote server, and again I get the following error message:
Schema specified is not valid. Errors:
App_Code.myentity.csdl(569,10) : error 0005: Data at the root level is invalid. Line 569, position 10.
I looked up what is in position 569 (of the csdl part), it's one of the following lines (I don't know exactly how the start of the csdl as separate file is:)
</AssociationSet>
</EntityContainer>
</Schema>
</edmx:ConceptualModels>
I just don't understand why it's working on my local machine and not on the remote one. I created the database on the remote machine using a script from the local MSSQL database. So they are equal. Any idea? I'm quite desperate...
Thanks
Alex

2 things to check:

1. Make sure the server has the same version of EF (check the assemblies in the site's Bin folder)

2. Make sure your connection string in web.config is correct. When you recreated the model, VS probably created a new connection string for you so it's easy to compare the old one with the new one.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Thanks for your reply:
The content of the bin folder: Aren't these file I have to upload from the local machine to the remote machine? If not, where do I get them?
Thanks
Alex

I deleted the website, uploaded all the files again, and now it's back working ok. No idea what happened.....

Hi Alex,

Glad to hear it's working again.

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!