创建数据库和数据表

using System;
using System.Data;
using System.Data.SqlClient;


namespace ConsoleApp1
{
    internal class Program
    {
        static void Main(string[] args)
        {
            SqlConnection myConn = new SqlConnection("Data Source=CDO1609\\SQLEXPRESS;database=master;Trusted_Connection=SSPI;");

            try
            {
                myConn.Open();

                string str = "CREATE DATABASE MyDatabase35 ON PRIMARY " +
                  "(NAME = MyDatabase_Data35, " +
                  "FILENAME = 'C:\\Program Files\\Microsoft SQL Server\\MSSQL12.SQLEXPRESS\\MSSQL\\DATA\\MyDatabaseData35.mdf', " +
                  "SIZE = 5MB, MAXSIZE = unlimited, FILEGROWTH = 1mb)" +

                  "LOG ON (NAME = MyDatabase_Log35, " +
                  "FILENAME = 'C:\\Program Files\\Microsoft SQL Server\\MSSQL12.SQLEXPRESS\\MSSQL\\DATA\\MyDatabaseLog35.ldf', " +
                  "SIZE = 1MB, MAXSIZE = 5MB, FILEGROWTH = 10%)";
                SqlCommand myCommand = new SqlCommand(str, myConn);
                myCommand.ExecuteNonQuery();


                str = "CREATE TABLE Test (Id INTEGER PRIMARY KEY, Name CHAR(10), Address CHAR(10))";
                myCommand = new SqlCommand(str, myConn);
                myCommand.ExecuteNonQuery();
            }
            catch (System.Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
            finally
            {
                if (myConn.State == ConnectionState.Open) myConn.Close();
            }      
        }   
    }
}