public override DatabaseServerVersion GetVersion() { using (var cmd = Connection.CreateCommand()) { cmd.CommandText = "SELECT SERVERPROPERTY('productversion') as VersionNumber, @@VERSION as VersionDesc"; using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { string name = reader.GetString(0); string desc = reader.GetString(1); var res = new DatabaseServerVersion(name); var lines = desc.Split('\n'); res.Description = lines[0].Trim(); switch (res.V1) { case 7: res.SellingName = "SQL Server 7"; break; case 8: res.SellingName = "2000"; break; case 9: res.SellingName = "2005"; break; case 10: res.SellingName = "2008/2008 R2"; break; case 11: res.SellingName = "2012"; break; } return(res); } } } return(null); }
public static bool Is_2008(this DatabaseServerVersion version) { return(version != null && version.IsMinimally(10, 0, 0)); }