Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Apr 29th, 2012  |  syntax: None  |  size: 1.02 KB  |  hits: 15  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Can't immediately connect to newly-created SQL Server database
  2. public static void CreateClientDatabase(string serverName, string databaseName)
  3. {
  4.     using (var connection = new SqlConnection(GetClientSqlConnectionString(serverName, String.Empty)))
  5.     {
  6.         var server = new Server(new ServerConnection(connection));
  7.         var clientDatabase = new Database(server, databaseName);
  8.  
  9.         clientDatabase.Create();
  10.         server.ConnectionContext.Disconnect();
  11.     }
  12. }
  13.        
  14. public static void CreateClientDatabaseObjects(string createDatabaseObjectsScriptPath, string serverName, string databaseName)
  15. {
  16.     using (var connection = new SqlConnection(GetClientSqlConnectionString(serverName, databaseName)))
  17.     {
  18.         string createDatabaseObjectsScript = new FileInfo(createDatabaseObjectsScriptPath).OpenText().ReadToEnd();
  19.         var server = new Server(new ServerConnection(connection));
  20.  
  21.         server.ConnectionContext.ExecuteNonQuery(createDatabaseObjectsScript);
  22.         server.ConnectionContext.Disconnect();
  23.     }
  24. }