Entity Framework Changing from SQL Server 2005 to 2008 R2
What changes do I need to make to get my entity data model to a new database instance on another server running SQL Server 2008 R2? I have changed the connection string in the Web.config and chan开发者_开发百科ged ProviderManifestToken="2008". If I try to refresh or make any changes I am given errors stating that nothing is mapped any more. Thank you for your help!
Just some general advice: first migrate the model with data from SQL Server 2005 to SQL Server 2008 R2 (use any approach, for example, this or this).
After this create a brand new entity model on SQL Server 2008. Compare the models' XML, make necessary changes in the model created for SQL Server 2005 (maybe you made a mistake in the ProviderManifestToken spelling).
Check that the data types are correspond, and actually that's all.
精彩评论