With LINQ to SQL, you can set up mappings between C# classes and an implied database schema either
by decorating the classes with special attributes or by writing an XML.
Following is a c# 4.0 code that describes first approach i.e. Linq to Sql mapping by decorating classes with special attributes.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Data.Linq.Mapping;
using System.Data.Linq;
[Table(Name="Jobs")] public class Job
{
[Column(IsPrimaryKey=true, IsDbGenerated=true, AutoSync=AutoSync.OnInsert)]
internal int JobID { get; set; }
[Column] public string JobTitle { get; set; }
[Column] public long Salary { get; set; }
}
[Table(Name="Applications")] public class Application
{
[Column(IsPrimaryKey=true, IsDbGenerated=true, AutoSync=AutoSync.OnInsert)]
internal int ApplicationID { get; set; }
[Column] public int JobID { get; set; }
[Column] public DateTime DateApplied { get; set; }
}
String ConStr=”"Data Source=localhost;Initial Catalog=JobsDB;Integrated Security=SSPI;"
DataContext dc = new DataContext(connectionString); // Get a live DataContext
dc.GetTable<Job>(); // Tells dc it's responsible for persisting the class Job
dc.GetTable<Application>(); // Tells dc it's responsible for persisting the class Application
dc.CreateDatabase(); // Causes dc to issue CREATE TABLE commands for each class
Above code will create JobsDB along with tables Jobs and Applications.
