This is a general question about the direction of what to learn next. I need to do some advanced record sorting and displaying and I feel like I'm pushing up against the limits of the SQLDataSource and DataRepeater. If I want to manually code the connetion
to the database, the filtering of records, and the displaying of them on a page, what's the best avenue to learn that?
Is the technology I'm searching for ADO.Net? or Linq? Where should I invest my time.
JStellato
Member
147 Points
224 Posts
What direction should I go with my Application?
Feb 15, 2012 08:30 PM|LINK
This is a general question about the direction of what to learn next. I need to do some advanced record sorting and displaying and I feel like I'm pushing up against the limits of the SQLDataSource and DataRepeater. If I want to manually code the connetion to the database, the filtering of records, and the displaying of them on a page, what's the best avenue to learn that?
Is the technology I'm searching for ADO.Net? or Linq? Where should I invest my time.
Thanks for your input!
ignatandrei
All-Star
135077 Points
21664 Posts
Moderator
MVP
Re: What direction should I go with my Application?
Feb 15, 2012 08:55 PM|LINK
http://www.asp.net/mvc
JStellato
Member
147 Points
224 Posts
Re: What direction should I go with my Application?
Feb 15, 2012 10:22 PM|LINK
Is MVC the best choice for granular control over record sets, and Data?
ignatandrei
All-Star
135077 Points
21664 Posts
Moderator
MVP
Re: What direction should I go with my Application?
Feb 15, 2012 10:58 PM|LINK
It;s the best choice versus separating responsabilities: loading data(ORM), business layer, gui.
JStellato
Member
147 Points
224 Posts
Re: What direction should I go with my Application?
Feb 16, 2012 12:12 AM|LINK
Sure, but in regards to records and database access, is ADO.NET the technology I'm looking to learn if I stay with web forms?
ignatandrei
All-Star
135077 Points
21664 Posts
Moderator
MVP
Re: What direction should I go with my Application?
Feb 16, 2012 01:16 AM|LINK
ADO.NET is just the basics. You should add EF and/or other ORM, like NHibernate
JStellato
Member
147 Points
224 Posts
Re: What direction should I go with my Application?
Feb 16, 2012 01:39 AM|LINK
Ok, but is ADO.net have more control than the SQLDataSource? And I have no idea what EF is, or ORM
I'll google NHibernate
Thanks
ignatandrei
All-Star
135077 Points
21664 Posts
Moderator
MVP
Re: What direction should I go with my Application?
Feb 16, 2012 07:05 AM|LINK
YEs.
EF = Entity Framework
ORM = any technology for binding tables to source code.
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: What direction should I go with my Application?
Feb 17, 2012 12:57 AM|LINK
It just depends on your need：
1）If you want to execute more data contents and you just come from ADO to deal with them，ADO.NET looks nicer。
2）If you want to do program like OOP thoughts，EF or any other ORM tools will be your best choice。