* IBM to offer mobile security as a service IBM will start delivering mobile security-as-a-service (MaaS) through its own cloud infrastructure in India, a move that is expected to better address in-country data requirements... IBM Spectrum Computing: IBM has enlarged its portfolio of software-defined infrastructure solutions with cognitive features for workload management.  * LiFi internet technology has been introduced, the new type of wireless internet connection that gives 100 times faster than traditional WiFi -- Invented by Professor Harald Haas from the University of Edinburgh. * Sci. Rachid Yazami has developed a smart chip that charges smartphones in less than 10 minutes. BenQ has launched BlueCore projector - Consumer electronics major BenQ has launched its first BlueCore laser light source projector. For those unaware, devices with BlueCore laser technology have a high contrast output of 80000:1 with an extended lamp life and efficiency. *** 
  Jul 25 2016 9:54PM     Micheal
  4 Comments    28249 Views  
Here Micheal provided a short tutorial with example, Select, Insert, Update and Delete in LINQ C#.
Create a Employee Table in the Database

CREATE TABLE [dbo].[Employee]
        [ID] [int] IDENTITY(1,1) NOT NULL,
        [EmployeeName] [nvarchar](50) NOT NULL,
        [EmployeeDesc] [nchar](10) NOT NULL,
        [EmployeeAge] [int] NOT NULL,
        [EmployeeAddress] [nvarchar](max) NOT NULL,
        [EmployeeExperience] [int] NOT NULL

Steps to Create .dbml (LINQ to SQL Classes)
Step 1: Open Visual Studio and Create ASP.Net Web Application.
Step 2: Right click the solution and Select Add New Item.. select Linq to sql classes option from the list
Step 3: The image given belows shows to Select Linq to sql classes in Add New Item Popup Window
Step 4: After clicking .dbml file, Now we should drag all the tables from the Database (Server Explorer).
Step 5: After placing tables in DataContext file, you dbml should look like this.
For .dbml files the database connection string is defined in the web.config file as:

<add name="DevelopmentConnectionString" connectionString="Data Source=XXX;Initial Catalog=DemoDB;User ID=sa;
 providerName="System.Data.SqlClient" />


Select Operation

<html xmlns="">
<head runat="server">
    <form id="form1" runat="server">
    <h2><b><div>The Developer Tips</div></b></h2>
    <h3><b>Gridview with LINQ</b></h3>

    <asp:GridView ID="gridviewEmp" runat="server">


    public partial class Default : System.Web.UI.Page
        protected void Page_Load(object sender, EventArgs e)

        private void BindGridView()
            using (DataContext objDataContext = new DataContext())
                var result = from c in objDataContext.Employees
                             where c.EmployeeAge >= 20
                             select c;                

                List<Employee> lstEmployee = result.ToList();
                gridviewEmp.DataSource = lstEmployee;

Insert Operation

        private void AddNewEmployee()
            using (DataContext objDataContext = new DataContext())
                Employee objEmp = new Employee();
                // fields to be insert
                objEmp.EmployeeName = "";
                objEmp.EmployeeAge = 25;
                objEmp.EmployeeDesc = "";
                objEmp.EmployeeAddress = "";
                objEmp.EmployeeExperience = 8;
                // executes the commands to implement the changes to the database

Update Operation

        private void UpdateEmployee()
            using (DataContext objDataContext = new DataContext())
                // Get single employee to update
                Employee objEmp = objDataContext.Employees.Single(emp => emp.EmployeeName == "john");
                //Field which will be update
                objEmp.EmployeeExperience = 10;
                // executes the commands to implement the changes to the database

Delete Operation

        private void DeleteEmployee()
            using (DataContext objDataContext = new DataContext())
                // Get single employee to update
                Employee objEmp = objDataContext.Employees.Single(emp => emp.EmployeeName == "john");              
                // executes the commands to implement the changes to the database

Result (Select Operation)
I hope this page will helps to learn Select, Insert, Update and Delete operations in LINQ C#. Thanks.

Nov 17 2016 7:06AM
Its wont work for me! Where objDataContext.Employees.InsertOnSubmit(objEmp); come from?
Arun Kumar
Nov 19 2016 12:56AM
Please refer Step 3, he was included LINQ to SQL Classess and renamed as DataContext.dbml

Then follow Step4 and Step5

In AddNewEmployee() method he was created a object for DataContext, ie objDataContext. From the object objDataContext you can have objDataContext.Employees.InsertOnSubmit(objEmp);"

Please see this link for more explanation about Getting Started with LINQ C#

I hope it helps you. Thanks
Nov 28 2017 8:25PM
Excellent Tutorial
Adam Fletcher
Nov 11 2018 9:42AM
You can try If you need Excel generation functionality for your .net application.

Recent Posts
Create Amazon ElasticCache Using Memcached in CSharp
Oct 29 2018 12:09PM Posted By Amose
Get Google Map Lat Lng (Geo Point) By Pincode in C#
Oct 28 2018 12:09PM Posted By Pranav
Google URL Shortener in C#
Oct 20 2018 12:09PM Posted By Sanjay
Bind Gridview from CSV file in Asp.Net C#
Oct 5 2018 12:09PM Posted By Michael
Call WebService method from jQuery in every 1 minute
Sep 26 2018 12:09PM Posted By John
Gridview custom CSS in ASP.Net
Sep 14 2018 12:09PM Posted By Micheal Ryan
Read excel file and bind to Gridview in C#
Sep 10 2018 12:09PM Posted By Micheal
Follow us on Facebook
Follow us on Google +
Recent post in your Email inbox.
Enter your email address: