首页 > 数据库技术 > 详细

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

时间:2019-03-15 16:16:36      阅读:473      评论:0      收藏:0      [点我收藏+]
技术分享图片
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

 

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

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

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!