if (!DbTableExists(connectionString, "[dbo].[Server]")) { try { using (SqlConnection connection = new SqlConnection(connectionString)) { string strCreateTable = @"CREATE TABLE [dbo].[Server] (ServerName nvarchar(15) PRIMARY KEY, LastUpdate datetime, )"; SqlCommand command = new SqlCommand(strCreateTable, connection); command.CommandType = CommandType.Text; connection.Open(); command.ExecuteReader(); connection.Close(); } } ... private static bool DbTableExists(string strConnection, string strTableNameAndSchema) { using (SqlConnection connection = new SqlConnection(strConnection)) { string strCheckTable = String.Format("IF OBJECT_ID('{0}', 'U') IS NOT NULL SELECT 'true' ELSE SELECT 'false'", strTableNameAndSchema); SqlCommand command = new SqlCommand(strCheckTable, connection); command.CommandType = CommandType.Text; connection.Open(); return Convert.ToBoolean(command.ExecuteScalar()); } }
<br /> string strCreateTable =<br /> @"CREATE TABLE [dbo].[Server] <br /> (ServerName nvarchar(15) PRIMARY KEY,<br /> LastUpdate datetime,<br /> )";<br />
dbo
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)