DataView.ToTable method in the 2.0 Framework

re: DataView.ToTable method in the 2.0 Framework

Brian Madsen — Fri, 09 Jun 2006 03:17:03 GMT

Hey Bill...i'm using TA's primarily for restricted data linked to an SP which calls data that a user on our network might not necessarily have access to normally.

that way the data access tier is produced for him/her without any interactions/requirements from them..allowing me to secure our data without exposing scenarios to new (or untrusted) users - all without having to give them access to the tables within sql server..

re: DataView.ToTable method in the 2.0 Framework

William — Fri, 09 Jun 2006 01:30:16 GMT

Bri - the ability to build a dataview with restricted columns is pretty awesome - I have a ton of helper classes to do stuff like this, or select distinct, so having it built in is nice b/c it's 'out of the box'. Now I have to install all of those libraries in the GAC on each box we develop on and it's a pain.

As far as TableAdapters - I haven't been all that impressed with them but admittedly I haven't had much experience with them yet. So like a lot of stuff that I'm not impressed with at first, it's probably b/c of ignorance (although I'm embarassed to say it, I wans't all that impressed with LINQ at first either - talk about doing a 180 degree turn on something).

What sort of scenarios are you using TableAdapters for?

re: DataView.ToTable method in the 2.0 Framework

Brian Madsen — Thu, 08 Jun 2006 11:01:45 GMT

yeah ADO.Net 2 has a lot of nice features...the ToTable() method is one of my favorites together with the TableAdapter...

keep it coming Bill!! always a good read!