LINQ to SQL support inserting data through object.

LINQ to SQL support inserting data through object.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.Linq;

namespace Linq2Sql_demo_doc

{

    /// <summary>

    /// Class to represent the SQL Server table

    /// Emp

    /// Id int

    /// Name varchar(50)

    /// </summary> ///

    [Table(Name="Emp")]

    public class Emp

    {

        //Comlumn mapping used from Data.Linq

        [Column(IsPrimaryKey=true, IsDBGenerated=true)]

        public int Id { get; set; }

        [Column]

        public string Name { get; set; }

    }

    //Class for the DataContext and List generation

    public class TestDB : DataContext

    {

        public Table<Emp> Emps;

        //Initializing base class constructor

        public TestDB(string s) : base(s) { }

    }

    class Program

    {

        static void Main(string[] args)

        {

            string strConnection =

@"Data Source=.\sqlexpress;Initial Catalog=TestDB;";

            TestDB db = new TestDB(strConnection);

            Emp emp = new Emp();

            emp.Name = "New Employee";

            db.Emps.Add(emp);

            db.SubmitChanges();

        }

    }

}

All the methods are coming from DataContext class (responsible for SQL query generation). The above method converts the object addition to DML query.

Namoskar!!!