LINQ TO SQL
1)Used for data handling with SQL Server databases only.
2)Uses the extension methods of System.Linq.Queryable class.
3)Introduced in .net Framework 3.0
4)DataContext is used for Database connectivity.
5)Syntax and coding is somewhat complex.
6)Uses Entity classes.
ADO.NET
1)Used for data handling with any database: SQL Server/Access/Oracle/Excel etc.
2)Does not use the extension methods of System.Linq.Queryable class.
3)There since the .net Framework 1.0
4)SqlConnection/OleDbConnection are used for database connectivity
5)Easier syntax and coding.
1)Used for data handling with SQL Server databases only.
2)Uses the extension methods of System.Linq.Queryable class.
3)Introduced in .net Framework 3.0
4)DataContext is used for Database connectivity.
5)Syntax and coding is somewhat complex.
6)Uses Entity classes.
ADO.NET
1)Used for data handling with any database: SQL Server/Access/Oracle/Excel etc.
2)Does not use the extension methods of System.Linq.Queryable class.
3)There since the .net Framework 1.0
4)SqlConnection/OleDbConnection are used for database connectivity
5)Easier syntax and coding.
No comments:
Post a Comment