Perform Insert into in c#List

Question

One could give an example of what an sql Insert would look like in a list in c#?

Answer 1

How to store a List<Object> in a database?

in this question you can see some examples of how to do Insert with c#, in the Gypsy answer is used only EnityFramework. In Lucas' answer, he uses Dapper and EntityFramework

But to make Insert used only SQL commands, you have to use the SqlConnection and SqlCommand , getting something like.

using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=Banco;Integrated Security=True;MultipleActiveResultSets=True"))
{
    SqlCommand command = new SqlCommand("INSERT INTO [dbo].[AspNetRoles] ([Id],[Name]) VALUES (@Id, @Name)", conn);

    command.Parameters.Add("@Id", SqlDbType.UniqueIdentifier).Value = Guid.NewGuid();
    command.Parameters.Add("@Name", SqlDbType.NVarChar, 256).Value = "Nome";

    conn.Open();
    command.ExecuteNonQuery();
}

Answer 2

        tb_User tb = new  tb_User ();
        tb.Nome="Manuel";
        tb.Idade=30;

        DB.DB.AddTotb_User(tb);
        DB.DB.Connection.Open();
        DB.DB.SaveChanges();
        DB.DB.Connection.Close();

Entity Framework.