Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Dynamic Data Scaffolding

Author  Topic 

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2011-08-31 : 10:06:37
I am thinking to use Dynamic data scaffolding of ASP.net

http://msdn.microsoft.com/en-us/library/ee377606.aspx

is this a good idea for best speed of data query in the app.?

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2011-08-31 : 11:55:24
>>is this a good idea for best speed of data query in the app.?
I have no experience with it but just looking at the link I would say no. If speed is your top priority then I would stay away from any solution that generates the sql code for you.

The other thing I don't like about this solution is that usually the logical model that users interact with is rarely aligned with the physical model that would be exposed via scaffolding.

Finally, this (link excerpt) would be a showstopper for me:
>>it can expose the whole database to unauthorized access, which poses a security risk.


Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -