T-SQL
I've been working on membership pages to replace WSAT.
--> One could build an entity data model (.edmx) of the membership database, give the program read/write access, and pound away. That would be a pretty easy way to go, having read the asp .net 4 book.
--> Or, one could use the classes and T-SQL functions provided by "using System.Web.Security" (in C#). This is easy enough, but when doing this I miss having the built-in objects and intellisense provided with the entity data model. I find myself chopping up pages to make the presentation easy to manage.
--> I went poking around on the web and found somebody who was putting the information returned by the System.Web.Security classes into XML. That gave him some structure, but he was always having to specify details of grid controls and such. Grid sorting and paging becomes tricky. (I haven't figure out the trick yet, but having spent a day to get very little progress, I am loosing interest fast.)
Surely there is a better way! Where would I learn more about this?
Also, do you have a good reference for T-SQL itself, and how to turn those procedures into classes? I'll be tackling a bigger project next, and I would like to use T-SQL for that project.
|
