private static bool CheckDatabaseExists( string databaseName){{string sqlCreateDBQuery;bool result = false;try{SqlConnection tmpConn = new SqlConnection(@Data Source=(localdb)\ProjectsV13;Initial Cat...

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; }
}
织梦狗教程
本文标题为:c#检测是否存在数据库(SQL SERVER)


基础教程推荐
猜你喜欢
- C# protobuf自动更新cs文件 2023-02-08
- 5分钟用C#实现串口助手 2023-06-22
- C# 枚举的使用简介 2023-04-09
- c# – Python .NET,多线程和windows事件循环 2023-09-20
- c# String扩展 让你在PadLeft和PadRight时不再受单双字节问题困扰 2023-02-08
- C#流程控制详解 2023-06-21
- C#实现六大设计原则之迪米特法则 2023-05-16
- C#中异步和多线程的区别介绍 2023-06-07
- c# – 如何使用Windows任务计划程序执行.Net Core 2.0控制台应用程序? 2023-09-19
- UnityShader使用图像叠加实现运动模糊 2023-01-16