获得数据库的版本

2015-11-25 16:25:56  访问(1575) 赞(0) 踩(0)

    /// <summary>
    /// 获得数据库的版本
    /// </summary>
    /// <param name="conn"></param>
    /// <returns></returns>
    public SlowX.DAL.Enums.SqlServerVersion.EmSqlServerVersion GetEmSqlServerVersion
        (
            System.Data.SqlClient.SqlConnection conn
        )
    {
        if (conn == null)
            throw ThrowSlowXExceptions.NewSlowXExceptionParameterIsNullMessage(MethodBase.GetCurrentMethod(), "System.Data.SqlClient.SqlConnection conn");

        string serverVersion = conn.ServerVersion;

        if (serverVersion == null || serverVersion.Length == 0)
            throw ThrowSlowXExceptions.NewSlowXExceptionParameterIsNullMessage(MethodBase.GetCurrentMethod(), "conn.ServerVersion 为空。");

        int intVersion = 0;

        int idx = serverVersion.IndexOf('.');

        if (idx == -1)
            intVersion = int.Parse(serverVersion);
        else
            intVersion = int.Parse(serverVersion.Substring(0, idx));

        switch (intVersion)
        {
            case 8:
                return SlowX.DAL.Enums.SqlServerVersion.EmSqlServerVersion.SqlServer2000;
            case 9:
                return SlowX.DAL.Enums.SqlServerVersion.EmSqlServerVersion.SqlServer2005;
            case 10:
                return SlowX.DAL.Enums.SqlServerVersion.EmSqlServerVersion.SqlServer2008;
            default:
                throw ThrowSlowXExceptions.NewSlowXExceptionMessage(MethodBase.GetCurrentMethod(), " serverVersion = " + serverVersion + " 为未知版本。");
        }

    }

标签：获得数据库的版本 

上一条：

下一条：

相关评论

发表评论

类型：	留言 建议 疑问
内容：
	(Alt+Enter)