SQL Server and Visual Studio 2010
-
Can somebody point me to web pages/books on what features Visual Studio 2010 has to work with SQL Server. I've used VS (and SQL Server) for years but never really learned the things that is will do for you with SQL. (Why do I want to define a dataset through visual studio rather than in code? Things like that.) Thanks for your help. Jeff.
-
Can somebody point me to web pages/books on what features Visual Studio 2010 has to work with SQL Server. I've used VS (and SQL Server) for years but never really learned the things that is will do for you with SQL. (Why do I want to define a dataset through visual studio rather than in code? Things like that.) Thanks for your help. Jeff.
jbradshaw wrote:
(Why do I want to define a dataset through visual studio rather than in code? Things like that.)
You don't. In fact, you don't want DataSets at all, but that's a different subject. The Visual Studio designers are for designing things you actually see on the screen, not for things that lurk in the background that you don't see; like database access.
-
Can somebody point me to web pages/books on what features Visual Studio 2010 has to work with SQL Server. I've used VS (and SQL Server) for years but never really learned the things that is will do for you with SQL. (Why do I want to define a dataset through visual studio rather than in code? Things like that.) Thanks for your help. Jeff.
Are you thinking about the adapters in VS. If so then don't they are an abomination and a step backwards from what you are doing. It sounds like you have a functional DAL, stick with it. IMHO the adapters were designed for newbie developers to quickly get them an app with database access without them having any knowledge of what they are doing. This they achieved, problem is when the newbie wants to do something a little more complicated, the adapters fail miserably and we get the question in the forums.
Never underestimate the power of human stupidity RAH
-
jbradshaw wrote:
(Why do I want to define a dataset through visual studio rather than in code? Things like that.)
You don't. In fact, you don't want DataSets at all, but that's a different subject. The Visual Studio designers are for designing things you actually see on the screen, not for things that lurk in the background that you don't see; like database access.
PIEBALDconsult wrote:
In fact, you don't want DataSets at all, but that's a different subject.
Amen. Maybe I'm stupid, but I have never seen a real value in using data sets. I've always ended up writing my own DAL, because of performance issues and other shortcomings of the whole DataSet stuff. Especially when the data sets are potentially huge.
-- Kein Mitleid Für Die Mehrheit