Entity Framework 5

Discussion in 'Databases' started by AlienZ, Jan 7, 2013.

  1. Hi there,

    I developed a site with Visual Studio 2012 and Entity Framework 5.
    I deployed it to my hosting url and everything works 100%, but when I try to save to the database using entity framework 5, I get a big fat error.
    I have to state that I am new to web development and also entity faremwork, so I won't be surprised if this is a noob error :p

    The error I am getting is this:

    Schema specified is not valid. Errors: Model.AZWorldEFModel.csdl(2,9) : warning 0005: Could not find schema information for the attribute 'Namespace'. Model.AZWorldEFModel.csdl(2,36) : warning 0005: Could not find schema information for the attribute 'Alias'. Model.AZWorldEFModel.csdl(2,49) : error 0005: The 'http://schemas.microsoft.com/ado/2009/02/edm/annotation:UseStrongSpatialTypes' attribute is not declared. Model.AZWorldEFModel.csdl(2,2) : error 0010: The element Schema in namespace http://schemas.microsoft.com/ado/2009/11/edm was unexpected for the root element. The expected Schema in one of the following namespaces: http://schemas.microsoft.com/ado/2006/04/edm, http://schemas.microsoft.com/ado/2007/05/edm, http://schemas.microsoft.com/ado/2008/09/edm

    I have tried a number of suggestions I found searching around on the net and nothing is working for me.
    Any suggestions would be greatly appreciated and if EF 5 is not supported, please let me know which is the latest version that is supported and I'll try reverting back to an earlier version.

    As far as the connection string goes, I used the connection string EF 5 generated in the web.config file and just added the needed bits provided by the control panel for the DB running on my hosting url.

    Thanx in advance!
     
  2. No response in more than 3 weeks...
    I am then left to assume that I cannot use VS2012 with EF 5.
    My project works 100% on my local machine but would not work on the hosting.
     
  3. Elshadriel

    Elshadriel Winhost Staff

    Hi,

    Sorry for the late response. Entity Framework 4 is supported on our servers, but you can not create/drop the database using code. I know that other customers have gotten it working by creating their database locally and then restore it using the Control Panel. I'm not sure what other piece of advice I can give you as I am not that familiar with Entity Framework. I'm not sure if it makes a difference if you're on Windows 2008/IIS7 and Windows 2012/IIS8.
     
  4. Hi Elshadriel,

    I have created a ticket with support and with the help of Dmitri and Jonnathan they have suggested that I migrate my app to Windows Server 2012 with IIS 8. I will try to get the appropriate permissions at work to test my app on Windows Server 2012 with IIS 8 first before migrating.

    Thanx for the response!
     
  5. Please note that this matter has been resolved.
    My account was moved to Windows Server 2012 with IIS 8 and the error is not appearing anymore.
    Thanx to everybody that helped resolve this problem!
     
  6. Elshadriel

    Elshadriel Winhost Staff

    Great! I'm glad to hear that. :)
     

Share This Page