I created a new database called "staj" and imported 3 excel files into it. I edited the column names and arranged the primary keys. After that, I opened a new web form in Visual Studio and added my database to the project using Entity Framework. It was all fine until I created a new table called UserList and tried to use it in Visual Studio, it says it could not be found. I tried to update Visual Studio by going to Tools -> SQL Server -> New Schema Comparison.
我创建了一个名为“staj”的新数据库,并将3个excel文件导入其中。我编辑了列名并排列了主键。之后,我在Visual Studio中打开了一个新的Web表单,并使用Entity Framework将我的数据库添加到项目中。在我创建一个名为UserList的新表并试图在Visual Studio中使用它之前,它一切都很好,它说无法找到它。我尝试通过转到工具 - > SQL Server - >新架构比较来更新Visual Studio。
I then got stuck because I can't get past the "Choose Source" part even though I clicked new connection and connected to my SQL Database and tested it. It said it was fine but, I simply couldn't find how to see the changes I've made to SQL in Visual Studio. Refreshing or active syncing didn't work. How can I do this?
然后我陷入困境,因为即使我点击了新的连接并连接到我的SQL数据库并进行了测试,我也无法通过“选择源”部分。它说没关系,但是我根本找不到如何看到我在Visual Studio中对SQL所做的更改。刷新或主动同步不起作用。我怎样才能做到这一点?
1 个解决方案
#1
1
This whole time I've been choosing the wrong keywords. My answer lies here -> How to: Update an .edmx File when the Database Changes (Entity Data Model Tools)
这整个时间我一直在选择错误的关键字。我的答案就在这里 - >如何:数据库更改时更新.edmx文件(实体数据模型工具)
#1
1
This whole time I've been choosing the wrong keywords. My answer lies here -> How to: Update an .edmx File when the Database Changes (Entity Data Model Tools)
这整个时间我一直在选择错误的关键字。我的答案就在这里 - >如何:数据库更改时更新.edmx文件(实体数据模型工具)