What factors should affect the level of data access that I use in a new project?

Question

I will be teaching the sson class, and I need to explain what factors should influence your decision on data access technology. I am familiar with many data access methods such as Typed Data Sets, Linq to SQL, Linq to Entities, .netTiers, LLBLGen and custom calls with SQL connection objects and command objects. Some of my clients will only use stored procedures, and they will NOT discuss anything else. Some of my clients are NOT ready to install .NET 3.5. Some customers require an average level of web service in any web application. In most cases, I use data types and custom web services, or I use .netTiers with CodeSmith. What else should I think about?

Answer 1

: ... , , .

( , ):

• ( )
• , ( . , , , )
• , .

, .

Answer 2

, ( ). , "" ( ), .

:

ETL// / (BizTalk/SSIS) ( -, ..). / ( , ?) - 24/7? , , ..

, . ? , .

, , , " " - , , , ? /p >

, API ? ?

, Entity Framework/LINQ to SQL, , NHibernate ( ..), .

EDIT: , : . , , DAL , (, ). .

Answer 3

, norbertB . ( , , - - - , ...). , .

, , , , - . , , , , , , " ".

Answer 4

. -, , - . , , , , .

-, LINQ, , LINQ ( SQL, Entities, LLBLGen, ) . -, , -, , LINQ, .