uWNpxb5T

1using System;
2using System.Data.SqlClient;
3using System.Text;
4using static System.Console;
5
6namespace mssql
7{
8    class Program
9    {
10            static void Main(string[] args)
11            {
12                try
13                {
14                    // Build connection string
15                    SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
16                    builder.DataSource = "localhost";   
17                    builder.UserID = "sa";              
18                    builder.Password = "Passw0d00";      
19                    builder.InitialCatalog = "master";    //Datenbank
20
21                    // Connect to SQL
22                    WriteLine("Connecting to SQL Server ... ");
23                    using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
24                    {
25                        connection.Open();
26                        WriteLine("Connection Done.");
27
28                    Write("Dropping Database");
29                    String sql = "DROP DATABASE IF EXISTS [maiki]";
30
31                        using (SqlCommand command = new SqlCommand(sql, connection))
32                        {
33                            command.ExecuteNonQuery();
34                            WriteLine("Done.");
35                        }
36
37                    WriteLine("Create Database....");
38                    String sql1 = "CREATE DATABASE [maiki]";
39                    using (SqlCommand command = new SqlCommand(sql1, connection))
40                    {
41                        command.ExecuteNonQuery();
42                        WriteLine("Done.");
43                    }
44
45                    WriteLine("Create Table");
46                    StringBuilder sb = new StringBuilder();
47                    sb.Append("USE maiki;");
48                    sb.Append("CREATE TABLE User ( ");
49                    sb.Append(" Id int IDENTITY(1,1) NOT NULL PRIMARY KEY, ");
50                    sb.Append(" Name NVARCHAR(50), ");
51                    sb.Append(" Location NVARCHAR(50) ");
52                    sb.Append("); ");
53                    sb.Append("INSERT INTO User (Name, Location) VALUES ");
54                    sb.Append("(N'Tom', N'Australia'), ");
55                    sb.Append("(N'Luisa', N'USA'), ");
56                    sb.Append("(N'Heinz', N'Germany'); ");
57
58                    String sql2 = sb.ToString();
59                    using (SqlCommand command = new SqlCommand(sql2, connection))
60                    {
61                        command.ExecuteNonQuery();
62                        WriteLine("Done..");
63                    }
64                }
65            }
66                catch (SqlException e)
67                    {
68                         WriteLine(e.ToString());
69                    }
70
71                WriteLine("All done. Press any key to finish...");
72                ReadKey(true);
73            }
74        }
75    }