English 中文(简体)
如何在运行时读取csdl、ssdl、msl以及如何从edmx文件升级表
原标题:how to read csdl,ssdl,msl in run time and how to Upgrade Tables from edmx file

如何在运行时读取csdl、ssdl、msl。如果我们更改了一个模式,那么如何升级表,即如果我们有edmx(在一个表中,让Employee等),那么数据库向导将生成一个create-eemployee的脚本。如果我们修改edmx并添加一个one-table(如Account等)和更改一个employee表(即删除一个coloum),那么edmx将生成一个alter-and-create脚本。

问题回答

默认数据库脚本生成只能为新数据库创建脚本。幸运的是,这个功能可以修改。数据库脚本生成由工作流或T4模板处理。您可以构建自己的逻辑,并定义所需的任何逻辑。

Visual Studio扩展管理器已经提供Entity Designer Database Generation Power Pack为数据库生成提供了几个新的工作流和T4模板,包括“生成迁移TSQL和部署”工作流。此工作流应使用VS 2010高级(和终极)数据库功能将当前数据库与新生成的脚本进行比较,创建差异脚本并进行部署。我个人不使用这些自动功能。我总是手动生成diff脚本(借助VS或RedGate工具)。





相关问题
Manually implementing high performance algorithms in .NET

As a learning experience I recently tried implementing Quicksort with 3 way partitioning in C#. Apart from needing to add an extra range check on the left/right variables before the recursive call, ...

Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

How do I compare two decimals to 10 decimal places?

I m using decimal type (.net), and I want to see if two numbers are equal. But I only want to be accurate to 10 decimal places. For example take these three numbers. I want them all to be equal. 0....

Exception practices when creating a SynchronizationContext?

I m creating an STA version of the SynchronizationContext for use in Windows Workflow 4.0. I m wondering what to do about exceptions when Post-ing callbacks. The SynchronizationContext can be used ...

Show running instance in single instance application

I am building an application with C#. I managed to turn this into a single instance application by checking if the same process is already running. Process[] pname = Process.GetProcessesByName("...

How to combine DataTrigger and EventTrigger?

NOTE I have asked the related question (with an accepted answer): How to combine DataTrigger and Trigger? I think I need to combine an EventTrigger and a DataTrigger to achieve what I m after: when ...

热门标签