---
title: "LINQ to SQL Backward compatibility:"  
description: "using System;  using System.Collections.Generic;  using System.Linq;  using System.Text;  using System.Data.Linq;  using System.Data.Linq.Mapping;  us"  
author: "Gaurav Shukla"  
published: 2012-01-05  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/277/linq-to-sql-backward-compatibility  
category: "linq"  
tags: ["linq"]  
reading_time: 1 minute  

---

# LINQ to SQL Backward compatibility:

using System;\
using System.Collections.Generic;\
using System.Linq;\
using System.Text;\
using System.Data.Linq;\
using System.Data.Linq.Mapping;\
using System.Data;\
using System.Data.SqlClient;\
\
[namespace](https://www.mindstick.com/articles/12552/namespace) GetCommandLinq\
{\
class Program\
{\
[static void](https://www.mindstick.com/interview/2715/can-we-write-static-public-void-instead-of-public-static-void) Main(string[] args)\
{\
DataContext oDataContext = new DataContext("[data source](https://www.mindstick.com/interview/808/what-is-a-data-source)=WRHNDEV03\\SQLEXPRESS; initial catalog=testing; [integrated security](https://www.mindstick.com/forum/159040/what-is-the-difference-between-integrated-security-true-and-integrated-security-sspi)=true");\
var vResult=from stud in oDataContext.GetTable<student>() select stud;\
IDbCommand oIDbCommand = oDataContext.GetCommand(vResult);\
[SqlDataAdapter](https://www.mindstick.com/interview/33991/what-is-sqldataadapter) oSqlDataAdapter = new SqlDataAdapter();\
oSqlDataAdapter.SelectCommand = ([SqlCommand](https://www.mindstick.com/forum/91/difference-between-sqlcommand-and-sqlcommandbuilder))oIDbCommand;\
[DataTable](https://www.mindstick.com/blog/195/datatable-in-ado-dot-net) oDataTable = new DataTable("mydata");\
try\
{\
oIDbCommand.Connection.Open();\
oSqlDataAdapter.FillSchema(oDataTable, SchemaType.Source);\
oSqlDataAdapter.Fill(oDataTable);\
for(int iIndex=0;iIndex<oDataTable.Rows.Count;iIndex++)\
{\
Console.WriteLine("Roll No = " + oDataTable.Rows[iIndex][0]);\
Console.WriteLine("Name = " + oDataTable.Rows[iIndex][1]);\
Console.WriteLine("Address = " + oDataTable.Rows[iIndex][2]);\
Console.WriteLine("Age = " + oDataTable.Rows[iIndex][3]);\
Console.WriteLine("Email = " + oDataTable.Rows[iIndex][4]);\
Console.WriteLine("\n");\
}\
}\
catch ([Exception](https://www.mindstick.com/articles/1824/objective-c-exception-handling) ex)\
{\
Console.WriteLine(ex.Message);\
}\
finally\
{\
oIDbCommand.Connection.Close();\
}\
Console.Read();\
}\
}\
\
\
[Table (Name ="student")]\
public class student\
{\
[Column(Name = "in_stud_id", IsPrimaryKey = true)]\
public int iStudId;\
\
[Column(Name = "nvc_name")]\
public string sName;\
\
[Column(Name = "nvc_address")]\
public string sAddress;\
\
[Column(Name = "in_age")]\
public int iAge;\
\
[Column(Name = "nvc_email")]\
public string sEmail;\
}\
}

---

Original Source: https://www.mindstick.com/blog/277/linq-to-sql-backward-compatibility

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.