SQL Server Express / MS Access LINQ features, which one to use?

Question

I have several front-end ASP.Net databases where MS Access is internal. I am trying to use the ASP.Net dynamic data website. Should I change this database to SQL Server Express or something else to simplify it or work with MS Access.

Answer 1

Choose SQL Express for the following reasons:

• Scaling . MS Access will never scale. After you go through about 10 simultaneous connections, you will begin to see problems. SQL Express will scale. You can always move SQL Express before installing SQL Server completely. Although this applies to some extent to Access, some of your SQL statements and data types may not pass purely.
• Security . SQL Server has a much better security model than Access. You can lock the circuit in your db for each user. You can also better control user access (I think user-developer versus user-tester and manufacturer).
• . . -, Access , SQL Server Express, , .
• . , LINQ, SQL Server. , .

Answer 2

Jet - , , . , - http://trigeminal.com, Jet , ( Microsoft), , 100 . .

/ Jet - , LAN-, - 20 50 , .

, Access Jet , , Jet . , Jet -, , Windows - - Apache ( PHP-) ( ) , Windows ( Linux, ). -, - , MySQL .

, , , . , ASP.NET, SQL Server, , . Jet back SQL Server , , .

Answer 3

LINQ to DataSets Linq Access.mdb .accdb.

http://msdn.microsoft.com/en-us/library/bb386977.aspx http://blogs.msdn.com/adonet/archive/2007/01/26/querying-datasets-introduction-to-linq-to-dataset.aspx