Subsonic in asp.net - a good approach or not?

Question

I am trying to make an enterprise application in asp.net. Is Subsonic the best approach or not?

How to write code using Subsonic in asp.net?

Or is there another way to access data from a database if we want to get thousands of records.

Answer 1

You have many options here, I personally prefer the Entity Framework , but I know that NHibernate is also a powerful and widely used ORM.

Personally, I do not suggest going with Linq2Sql . Entity Framework is better as a successor to Linq2Sql .

NHibernate is very effective, but looks more complicated to me (compared to the Entity Framework ).

I have no idea about SubSonic , but I heard about it.

The choice between them? It is completely up to you.

The links below can help you choose wisely:

Subsonic Vs NHibernate

Subsonic 3 VS Entity Framework

Entity Framework 4 vs NHibernate

Answer 2

I suggest using LINQ to SQL: http://msdn.microsoft.com/en-us/library/bb425822.aspx

LINQ to SQL provides an easy way to interact with your database for your enterprise application.

There is also a lot of documentation on using LINQ to SQL online compared to other methods.

• Part 1: Introduction to LINQ to SQL
• Part 2: Defining our data model models
• Part 3: query our database
• Part 4: Updating our database
• Part 5: UI binding using <asp: LinqDataSource> Management
• Part 6: Retrieving Data Using Stored Procedures
• Part 7: Updating our database using stored procedures
• Part 8: Executing Custom SQL Statements
• Part 9: Using a custom LINQ expression using <asp: LinqDataSource> Management

Answer 3

You have many options.

You should research a little, at least before making your choice.

I would think...

• Entity structure
• NHibernate
• Linq 2 SQL
• Dapper