Geek Answers Handbook

Learn LinqToSql or stick with ADO.NET?

I am discussing which technology to use for the upcoming ASP.NET project.

Assumptions:

  • I will use Visual Studio 2008 SP1 (.NET Framework 3.5)
  • The back-end will be a SQL Server 2005 database (or possibly 2008)
  • The code will be written in C #
  • I already have experience with LinqToObjects and LinqToXml
  • I also have experience working with ADO.NET and some already built libraries.
  • The project is relatively small
  • About five screens will be presented on the website
  • There will be six or seven tables in the database.
  • 25-50 active users will be available
  • Transactions per day are likely to be around 5-10 peaks.
  • Minimum personal data will be saved.
  • The consequences of failure or hacking the site will be minimal.

Parameters:

  • ADO.NET. LinqToObjects, DataSet.

  • , Linq, LinqToSql.

:

, 1, Linq . 2 , , , , LinqToSql, , Entity Framework.

:

  • LinqToSql, Linq?

  • LinqToSql, , Microsoft ?

  • LinqToSql Entity Framework ?

  • , ?

Update:

, : marc_s , LinqToSql , , .NET 4.0. : http://damieng.com/blog/2009/06/01/linq-to-sql-changes-in-net-40.

, , LinqToSql , .

, , : Entity Framework ?

.

LinqToSql, :

  • , . "" "" , .
  • , .
  • LinqToSql , SqlMetal.
  • /, .

, 1 . . , Windows Forms , , ADO.NET.

, , SqlMetal . , , . ( - , ), , SqlMetal - , .

+5
5

LINQ to Sql , LINQ Xml ( Linq " " ")...

Linq To Sql Microsoft, EF. .

Linq To Sql EF. EF , ( 7 ).

LINQ. , SP + ADO.NET. ORM - . ( ).

+10

Davide Vosti, , NHibernate ( LINQ).

EF - ​​ - T-SQL, .

EF, , - EF .NET 3.5. .NET 4, , ( LINQ to SQL ).

+5

1. LinqToSql, Linq?

, , . , , , , .

2.Is LinqToSql, , Microsoft?

, , Linq. , Microsoft Linq2Sql, marc_s. Linq2Sql Nerd Dinner (http://nerddinner.codeplex.com/)

3. LinqToSql Entity Framework ?

Linq2Sql Entity Framework, , . , - .

4., ?

, , Linq2Sql, , , , , . (, , , ).

+3

1 - Linq-to-Sql, Linq?

, 50% , , . LinqToSql , Linq.

2 - Linq-To-Sql, , Microsoft?

ORM. ORM, LinqToSql, , # 3 # 4 . Microsoft LinqToSql , , , EntityFramework . Microsoft , .

3 - Linq-To-Sql Entity Framework ?

ORM ORM. LinqToSql , EntityFramework, , . , EntityFramework LinqToSql.

4 - , ?

ORM .NET 3.5 NHibernate. NHibernate Linq, -, Microsoft ORM. , , NHibernate ADO.NET . LinqToSql EntityFramework .

0

Subsonic, Linq to SQL NHibernate.

NHibernate, , , Sql Server.

ORMS

0
source

More articles:


All Articles