Click here to Skip to main content
Click here to Skip to main content

Dynamically Build LINQ to SQL Classes at Runtime

, 13 Sep 2013 CPOL
Rate this:
Please Sign up or sign in to vote.
Dynamically build Linq2Sql classes based off SQL table

Introduction

The attached .cs file looks at a SQL table, generates a LINQ to SQL Object at runtime that can be used to insert, update, and query the database. It is useful for working with your own interactive C# interpreter. The problem it solves; you don't need to design an EDMX file and compile before using.

Using the Code

//make an IDbConnection
IDbConnection oconn = new System.Data.SqlClient.SqlConnection(
  @"Data Source=192.168.0.1;Initial Catalog=db;user id=usr;password=pwd;");

//pass the connection and the table you want
object o = DynamicL2S.L2SClassObject(oconn, "table");
Type itemType = o.GetType();

//create an instance and insert into db
using (DataContext dc = new DataContext(oconn))
{
    var item = (dynamic)Activator.CreateInstance(itemType, new Object[] { });

    item.oid = Guid.NewGuid();
    item.x = 9;
    item.y = 9;
    item.z = 9;
    item.color = Color.Blue.ToArgb();

    dc.GetTable(itemType).InsertOnSubmit(item);

    dc.SubmitChanges();
}

//retrieve all items
using (DataContext dc = new DataContext(oconn))
{
    var res = from r in dc.GetTable(itemType).Cast<dynamic>()
              select r;

    dataGridView1.DataSource = res.ToList();
}

//get properties
System.Reflection.PropertyInfo[] method = o.GetType().GetProperties();
foreach (System.Reflection.PropertyInfo oInf in method)
{
    ret += oInf.Name + " - " + oInf.PropertyType.Name + "\n";
}

Points of Interest

It uses the C# compiler to compile C# classes at run time. It uses object extension methods to force LINQ to allow use of dynamic type when casting.

Credit to Sources

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

oryan
Software Developer
United States United States
No Biography provided

Comments and Discussions

 
QuestionMore examples & minor problems PinmemberDewey12-Sep-13 22:59 
AnswerRe: More examples & minor problems Pinprofessionaloryan13-Sep-13 10:31 
GeneralRe: More examples & minor problems PinmemberDewey24-Sep-13 14:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.141015.1 | Last Updated 13 Sep 2013
Article Copyright 2013 by oryan
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid