I'm creating a system using SQL Server 2012 for database, but when this system is starting first time in a computer, I want the system create the database and tables for me no create this manual.
How to I create database with C#? And how to I set connect string? because normally I set database name in the connect string, but now, I need create database before
You can use SQL script, leave database name empty. Example code here :
static void Main(string[] args)
{
using (var conn = new SqlConnection("data source=DBServer; uid=UserName; pwd=Password;"))
{
using (var cmd = new SqlCommand())
{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = "Create Database NewDB;";
cmd.ExecuteNonQuery();
cmd.CommandText = "Use NewDB;CREATE TABLE dbo.Table1 (ID int, Data nvarchar(128));";
cmd.ExecuteNonQuery();
}
}
}
USE <dbName> in the same batch as another command. I'd suggest closing the connection after you create the DB, and then re-open it specifying the new DB in the connection string.
