当前位置:首页 > 数据库 > Sqlserver

c#检测是否存在数据库(SQL SERVER)

技术分享图片 技术分享图片
                private
                static
                bool CheckDatabaseExists( string databaseName)
{

        {
            string sqlCreateDBQuery;
            bool result = false;

            try
            {
                SqlConnection tmpConn = new SqlConnection(@"Data Source=(localdb)ProjectsV13;Initial Catalog=Example;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False;");

                sqlCreateDBQuery = string.Format("SELECT database_id from sys.databases WHERE Name  = ‘{0}‘", databaseName);
        
               using (tmpConn)
                {
                    using (SqlCommand sqlCmd = new SqlCommand(sqlCreateDBQuery, tmpConn))
                    {
                        tmpConn.Open();

                        object resultObj = sqlCmd.ExecuteScalar();

                        int databaseID = 0;

                        if (resultObj != null)
                        {
                            int.TryParse(resultObj.ToString(), out databaseID);
                        }

                        tmpConn.Close();

                        result = (databaseID > 0);
                    }
                }
            }
            catch (Exception ex)
            {
                result = false;
            }

            return result;
        }
}
View Code

 

原文:https://www.cnblogs.com/jack-jun/p/10537469.html


【说明】本文章由站长整理发布,文章内容不代表本站观点,如文中有侵权行为,请与本站客服联系(QQ:254677821)!

相关教程推荐

其他课程推荐