Create Database Using ADO.NET
Here, I'll programmatically construct the ADONETPracticeDb database. This code can be used in console programmers as well as Windows and web apps.
Code Example
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Ado.net_Practice
{
public static class CreateDatabaseUsingAdoNetCore
{
public static void CtreateDatabase()
{
string ConString = @"Server=localhost\SQLEXPRESS;Database=Test1;Trusted_Connection=True;";
SqlConnection con = new SqlConnection(ConString);
string query = "Create Database ADONETPracticeDb";
SqlCommand cmd = new SqlCommand(query, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
Console.WriteLine("Database Created Successfully");
}
catch (SqlException e)
{
Console.WriteLine("Error Details: " + e.ToString());
}
finally
{
con.Close();
Console.ReadKey();
}
}
}
}
Main Class Code
using Ado.net_Practice;
CreateDatabaseUsingAdoNetCore.CtreateDatabase();
Code Output
SSMS Database Create Successfully
Top comments (0)