Is subsonic in asp.net is a good approach or not?

Question

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

How do I write code using Subsonic in asp.net?

Or is there another way to access data from the database if we want to fetch thousands of record.

.NET ORM comparison: http://stackoverflow.com/questions/1377236/nhibernate-entity-framework-active-records-or-linq2sql/ — Michael Maddox, Jun 13 '11 at 11:48
This question is too vague, there is no objective answer without fully understanding your requirements. A detailed question may be suitable for http://programmers.stackexchange.com as the answer involves very little code and is subjective. — Sam Saffron, Jun 13 '11 at 22:46
the subsonic 3 is extreme slow. The subsonic 2 is fast, but need more optimization, but is very good. I use subsonic 2 on an enterprise application with my optimization, more than 300 tables, 4 database and I have super fast response and good stability, easy development. — Aristos, Jun 24 '11 at 20:08

score 2 · Answer 1 · edited May 23 '17 at 11:55

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

Personally I don't suggest going with Linq2Sql. Entity Framework is better and like a successor to Linq2Sql.

NHibernate is very powerful , but looks more tricky to me (compared to Entity Framework).

I have no idea about SubSonic, but I've heard of it.

Choosing between them? It's completely up to you.

Links below may help you choose wisely:

score 1 · Answer 2 · edited Jun 13 '11 at 19:32

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

There is also plenty of documentation on how to use LINQ to SQL online compared to other methods.

score 0 · Answer 3 · answered Jun 12 '11 at 08:15

0

You have a lot of options.

You should research a few at least before making your choice.

I would consider...

answered Jun 12 '11 at 08:15

Baldy

3 Answers3