EF5.0 支持sql2000吗?
用的是code first模式,sql2005会自动创建表,sql2000没创建,什么问题?
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!
Thx!