Create Database Using ADO.NET

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