Advertisement
Guest User

Untitled

a guest
May 8th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.60 KB | None | 0 0
  1. using System;
  2. using System.Data.SqlClient;
  3. using Dapper;
  4.  
  5. namespace api
  6. {
  7. public static class Bootstrapper
  8. {
  9. public static void Init()
  10. {
  11. var server = Db.ConnectionString = Environment.GetEnvironmentVariable("DB_SERVER") ?? @".\SQLEXPRESS2012";
  12. var database = Db.ConnectionString = Environment.GetEnvironmentVariable("DB_DATABASE") ?? "Test";
  13. var user = Db.ConnectionString = Environment.GetEnvironmentVariable("DB_USER_NAME") ?? "sa";
  14. var pass = Db.ConnectionString = Environment.GetEnvironmentVariable("DB_PASSWORD") ?? "sa";
  15. Db.ConnectionString = $"server={server};database=master;User Id={user};Password={pass};";
  16. using (var conn = new SqlConnection(Db.ConnectionString))
  17. {
  18. var sql = $"IF db_id('{database}') is null create database [{database}];";
  19. conn.Execute(sql);
  20. }
  21. Db.ConnectionString = $"server={server};database={database};User Id={user};Password={pass};";
  22. using (var conn = new SqlConnection(Db.ConnectionString))
  23. {
  24. const string sql = @"
  25. if not exists (select * from sysobjects where name='Projects' and xtype='U')
  26. create table Projects(
  27. Id int identity not null,
  28. Name nvarchar(50) not null,
  29. constraint PK_Projects primary key(id)
  30. )";
  31. conn.Execute(sql);
  32. }
  33. }
  34. }
  35.  
  36. public static class Db
  37. {
  38. public static string ConnectionString { get; set; }
  39. }
  40. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement