Create database connectionStrings ASP.NET

Question

Summarizing a little what I have, the app creates a sql database, if it is already created, it deletes it and recreates it.
I would like to understand the part of the code where it does this, which if I'm not mistaken is this.

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>  
    {  
        public ApplicationDbContext()  
            : base("DefaultConnection", throwIfV1Schema: false)  
        {  
            Database.SetInitializer(new IdentityDropCreateInitializer());  
        }  
  
        public static ApplicationDbContext Create()  
        {  
            return new ApplicationDbContext();  
        }  
    }  

Could you help me understand this part of asp.net code?
In the end, what I would like to do is tell the program not to create the database, just insert tables and data, but the database neither creates nor deletes it.
Thank you.

Answer 1

see:

https://www.entityframeworktutorial.net/code-first/database-initialization-strategy-in-code-first.aspx

Answer 2

Hi @Albert Peñaranda ,
You can learn more about the use of the Database.SetInitializer method in C# in the following documentation：

https://learn.microsoft.com/en-us/dotnet/api/system.data.entity.database.setinitializer?view=entity-framework-6.2.0

To add, delete, and modify the database in the ASP.NET, we first need to bind the database under the Web.Config file ASP.NET.

<connectionStrings>  
           <add name="TEST" connectionString="xxxxxxxxx;" providerName="System.Data.SqlClient"/>  
</connectionStrings>  

string strcon = ConfigurationManager.ConnectionStrings["Test"].ConnectionString;// Reads the connection string from the web.config file  
            SqlConnection con = new SqlConnection(strcon);// Defines the connection object  
            SqlCommand cmd = new SqlCommand();//Create a command object  
           cmd.Connection = con;// Sets the database connection properties of the command object  
            cmd.CommandText = "xxxxx";// Assign SQL statements to the command object  
            try  
            {  
                con.Open();//Open a database connection  
                SqlDataReader sdr = cmd.ExecuteReader();//Execute sql commands and get the query results  
                cmd.Connection = con;// Sets the database connection properties of the command object  
                cmd.CommandText = "select * from student";// Assign SQL statements to the command object  
                con.Close();//Close the database connection  
                con.Open();//Open a database connection  
                sdr = cmd.ExecuteReader();  
          }  
catch (Exception ex)  
            {  
                Response.Write(ex.Message);  
            }  
            finally  
            {  
                if (con.State == System.Data.ConnectionState.Open) // Determine whether the database connection is closed  
                    con.Close();//Close the database connection  
            }  

The addition, deletion, and modification of the operation is based on your SQL command. If you want to implement more features, please give me more details and I will do my best to help you solve the problem.

Best regards,
Qi You

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.