Anybody knows if SQL Server 2000 is supported in EF 6 for Code First? In the official websites I haven't found anything about which SQL Server versions are supported in EF 6. In some blogs I've found that SQL Server 2000 is not supported, but these blogs aren't from official sources. Looking at the source code of EF 6 it seems that is supported I've found some code with SQL Server 2000 considerations.
For example:
SqlVersion
is a class with an enum of SQL Server versions, SQL Server 2000 is in this enum.
https://entityframework.codeplex.com/SourceControl/latest#src/EntityFramework.SqlServer/SqlVersion.cs
// <summary>
// This enumeration describes the current SQL Server version.
// </summary>
internal enum SqlVersion
{
// <summary>
// SQL Server 8 (2000).
// </summary>
Sql8 = 80,
// <summary>
// SQL Server 9 (2005).
// </summary>
Sql9 = 90,
.....
TopClause
is the class that generates a select TOP
clause, in this class in the method WriteSql
, special SQL syntax is generated for SQL Server 2000.
https://entityframework.codeplex.com/SourceControl/latest#src/EntityFramework.SqlServer/SqlGen/TopClause.cs
public void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator)
{
writer.Write("TOP ");
if (sqlGenerator.SqlVersion
!= SqlVersion.Sql8)
{
writer.Write("(");
}
.....
And like theses class there are others with special considerations for SQL Server 2000? Anybody know if SQL Server 2000 is official supported in EF 6?
Thanks
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With