Entity Execute SQL Query : INSERT/UPDATE/DELETE (LINQ, Entity Framework)

        private void frmMain_Load(object sender, EventArgs e)
        {
            // Create new entities from Entities
            using (var db = new myDatabaseEntities())
            {
                // Insert
                string strSQL = string.Empty;
                strSQL = "INSERT INTO CUSTOMER ";
                strSQL += " (CUSTOMER_ID,NAME,EMAIL,COUNTRY_CODE,BUDGET,USED)";
                strSQL += " VALUES";
                strSQL += " ('C005','Rut Wisarut','[email protected]'";
                strSQL += ",'TH','5000000','0')";
                db.Database.ExecuteSqlCommand(strSQL);
            }
        }

    Private Sub frmMain_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        ' Create new entities from Entities
        Using db = New myDatabaseEntities()
            ' Insert
            Dim strSQL As String = String.Empty
            strSQL = "INSERT INTO CUSTOMER "
            strSQL += " (CUSTOMER_ID,NAME,EMAIL,COUNTRY_CODE,BUDGET,USED)"
            strSQL += " VALUES"
            strSQL += " ('C005','Rut Wisarut','[email protected]'"
            strSQL += ",'TH','5000000','0')"
            db.Database.ExecuteSqlCommand(strSQL)
        End Using
    End Sub

        private void frmMain_Load(object sender, EventArgs e)
        {
            // Create new entities from Entities
            using (var db = new myDatabaseEntities())
            {
                string strSQL = string.Empty;
                strSQL = "INSERT INTO CUSTOMER ";
                strSQL += " (CUSTOMER_ID,NAME,EMAIL,COUNTRY_CODE,BUDGET,USED)";
                strSQL += " VALUES";
                strSQL += " (@CustomerID,@Name,@Email";
                strSQL += ",@CountryCode,@Budget,@Used)";

                List<SqlParameter> parameterList = new List<SqlParameter>();
                parameterList.Add(new SqlParameter("@CustomerID", "C005"));
                parameterList.Add(new SqlParameter("@Name", "Rut Wisarut"));
                parameterList.Add(new SqlParameter("@Email", "[email protected]"));
                parameterList.Add(new SqlParameter("@CountryCode", "TH"));
                parameterList.Add(new SqlParameter("@Budget", 5000000));
                parameterList.Add(new SqlParameter("@Used", 0));
                SqlParameter[] Param = parameterList.ToArray();
                int result = db.Database.ExecuteSqlCommand(strSQL, Param);
            }
        }

    Private Sub frmMain_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        ' Create new entities from Entities
        Using db = New myDatabaseEntities()
            Dim strSQL As String = String.Empty
            strSQL = "INSERT INTO CUSTOMER "
            strSQL += " (CUSTOMER_ID,NAME,EMAIL,COUNTRY_CODE,BUDGET,USED)"
            strSQL += " VALUES"
            strSQL += " (@CustomerID,@Name,@Email"
            strSQL += ",@CountryCode,@Budget,@Used)"

            Dim parameterList As New List(Of SqlParameter)
            parameterList.Add(New SqlParameter("@CustomerID", "C005"))
            parameterList.Add(New SqlParameter("@Name", "Rut Wisarut"))
            parameterList.Add(New SqlParameter("@Email", "[email protected]"))
            parameterList.Add(New SqlParameter("@CountryCode", "TH"))
            parameterList.Add(New SqlParameter("@Budget", 5000000))
            parameterList.Add(New SqlParameter("@Used", 0))
            Dim Param As SqlParameter() = parameterList.ToArray()
            Dim result As Integer = db.Database.ExecuteSqlCommand(strSQL, Param)
        End Using
    End Sub

        private void frmMain_Load(object sender, EventArgs e)
        {
            // Create new entities from Entities
            using (var db = new myDatabaseEntities())
            {
                // Update 
                string strCustomerID = "C005";
                decimal iUsed = 100000;
                db.Database.ExecuteSqlCommand("UPDATE CUSTOMER SET USED = {0} WHERE CUSTOMER_ID = {1}"
                    , iUsed, strCustomerID);
            }
        }

    Private Sub frmMain_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        ' Create new entities from Entities
        Using db = New myDatabaseEntities()
            ' Update 
            Dim strCustomerID As String = "C005"
            Dim iUsed As Decimal = 100000
            db.Database.ExecuteSqlCommand("UPDATE CUSTOMER SET USED = {0} WHERE CUSTOMER_ID = {1}", _
                                          iUsed, strCustomerID)
        End Using
    End Sub

        private void frmMain_Load(object sender, EventArgs e)
        {
            // Create new entities from Entities
            using (var db = new myDatabaseEntities())
            {
                // Delete 
                string strCustomerID = "C005";
                db.Database.ExecuteSqlCommand("DELETE FROM CUSTOMER WHERE CUSTOMER_ID = {0}"
                    , strCustomerID);
            }
        }

    Private Sub frmMain_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        ' Create new entities from Entities
        Using db = New myDatabaseEntities()
            ' Delete 
            Dim strCustomerID As String = "C005"
            db.Database.ExecuteSqlCommand("DELETE FROM CUSTOMER WHERE CUSTOMER_ID = {0}", _
                                          strCustomerID)
        End Using
    End Sub