首页 新闻 赞助 找找看

EF5.0 支持sql2000吗?

0
悬赏园豆:10 [已解决问题] 解决于 2016-02-26 16:33

EF5.0 支持sql2000吗?

用的是code first模式,sql2005会自动创建表,sql2000没创建,什么问题?

Jaryleely的主页 Jaryleely | 菜鸟二级 | 园豆:367
提问于:2016-02-23 17:00
< >
分享
最佳答案
0

EF4's support for SQL Server 2000 is spotty; things like First and FirstOrDefault (or any functions that result in a TOP expression) will not work, for example. While the runtime may generate code that is compatible, the designer is no longer compatible with anything older than SQL Server 2005.

Unfortunately, that's what you're stuck with. Your best option (in the short term) would probably be to mirror a copy of your database in a SQL Server 2005 Express instance and point the designer to that.

While I realize that companies can have a significant investment in software and upgrading is not always feasible, SQL Server 2000 is 11 -- almost 12 -- years old, and it's not really reasonable to expect cutting-edge tools to support technology this old when multiple versions have been released since then.

Good luck!

收获园豆:10
爱编程的大叔 | 高人七级 |园豆:30839 | 2016-02-23 17:07

Thx!

Jaryleely | 园豆:367 (菜鸟二级) | 2016-02-23 17:31
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册