Today, in this article let’s play around with one of the interesting and most useful concepts in EDM Framework.
IntroductionToday, in this article let's play around with one of the interesting and most useful concepts in EDM Framework.Question: What is insert data with raw SQL query via EDM framework?In simple terms "It provides flexibility to insert data using raw SQL queries via EDM framework".Step 1: Create a new web applicationStep 2: Set up a new EDM framework with reverse engineering to the projectStep 3: The complete code of WebForm1.aspx looks like this:<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="InsertDataSQLQueryEntityApp.WebForm1" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head id="Head1" runat="server"> <title></title></head><body> <form id="form1" runat="server"> <div> <center> <table> <tr> <td> <asp:Label ID="Label1" runat="server" Text="Insert Data with Raw SQL Query via EDM Framework" Font-Bold="true"></asp:Label></td> </tr> </table> <br /> <br /> <table> <tr> <td> <asp:Label ID="Label2" runat="server" Text="Please Enter FirstName: " ForeColor="Brown" Font-Bold="true" Font-Italic="true"></asp:Label></td> <td> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td> </tr> <tr> <td> <asp:Label ID="Label3" runat="server" Text="Please Enter LastName: " ForeColor="Brown" Font-Bold="true" Font-Italic="true"></asp:Label></td> <td> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td> </tr> <tr> <td> <asp:Label ID="Label4" runat="server" Text="Please Enter Age: " ForeColor="Brown" Font-Bold="true" Font-Italic="true"></asp:Label></td> <td> <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td> </tr> <tr> <td colspan="2" align="center"> <asp:Button ID="Button1" runat="server" Text="Insert Data" OnClick="Button1_Click" BackColor="Orange" Font-Bold="true" /><br /> <br /> </td> </tr> </table> <br /> <br /> <table> <tr> <td colspan="3"> <asp:Label ID="Label5" runat="server" Font-Bold="true"></asp:Label></td> </tr> </table> </center> </div> </form></body></html>Step 4: The complete code of WebForm1.aspx.cs looks like this:using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using InsertDataSQLQueryEntityApp.Models;namespace InsertDataSQLQueryEntityApp{ public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(TextBox1.Text) || string.IsNullOrEmpty(TextBox2.Text) || string.IsNullOrEmpty(TextBox3.Text)) { Label5.Text = "Please Enter Some Values"; Label5.ForeColor = System.Drawing.Color.Red; } else { objContext.Database.ExecuteSqlCommand("insert into dbo.tblEmployee(FirstName, LastName, Age) VALUES ('" + TextBox1.Text + "', '" + TextBox2.Text + "', " + int.Parse(TextBox3.Text) + ")"); Label5.Text = "Data Successfully Inserted"; Label5.ForeColor = System.Drawing.Color.Green; TextBox1.Text = string.Empty; TextBox2.Text = string.Empty; TextBox3.Text = string.Empty; } } #region Instance MembersCompanyContext objContext = new CompanyContext(); #endregion }}Step 5: The output of the application looks like this:Step 6: The inserted data output of the application looks like this:I hope this article was useful for you. I look forward for your comments and feedback. Thanks Vijay.
Programming Strings using C#