实体框架4.3托管SQL Server无数据库创建权限 [英] Entity Framework 4.3 Hosted SQL Server No Database Create Permissions

问题描述

我的SQL Server由我的主机提供商托管。这意味着我没有权限重新创建（或创建）数据库。

这导致我对EF 4的问题 - 它认为表丢失，他们是谁我认为是由于无法重新创建数据库而导致的。

要概述：本地开发，首次运行到托管服务器，切换连接字符串，反对托管服务器，错误说无效的对象名称'dbo.Products'。

我有权创建除DB之外的其他任何东西

我在这个假设中是否正确，如何解决这个问题？

解决方案

在EF 4.3中，使用视频工作室中的工具菜单项中的软件包管理器控制台。这将允许您使用迁移来生成数据库脚本。更多信息

http://blogs.msdn.com/b/adonet/archive/2012/02/09/ef-4-3-code-based-migrations -walkthrough.aspx

你当然可以自己创建一个下载并创建脚本

My SQL Server is hosted by my hosting provider. This means that I don't have permission to recreate (or create) the database.

This is causing me a problem with EF 4 - it thinks the tables are missing, which they are. I think is caused by not being able to recreate the database.

To recap: developed locally, moving to hosted server for first time run, switched the connection string, run against the hosted server, error saying Invalid object name 'dbo.Products'.

I have permission to create anything else apart from the DB

Am I correct in this assumption and how do I work around this?

解决方案

In EF 4.3 you can use the Package Manager Console from the tools menu item in visual studio. This will allow you to use migrations to generate a DB script. More info here

http://blogs.msdn.com/b/adonet/archive/2012/02/09/ef-4-3-code-based-migrations-walkthrough.aspx

You could of course create a drop and create script yourself

这篇关于实体框架4.3托管SQL Server无数据库创建权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！