Which is more important, an efficient database or a well-designed client application that connects to the database? In my estimation, they are both equally important. After all, your database can be very well designed and extremely efficient, but that won’t matter to the end user if the client application they use to connect to your database is slow and unresponsive. While this book focuses on SQL Server server-side development functionality, I’ve decided to take a moment to introduce some of the tools available to create efficient SQL Server client applications. The .NET Framework, in particular, offers several options to make SQL Server 2008 client connectivity simple and efficient. In this chapter, I will discuss usingADO.NET and the .NET SqlClient as a basis for building your own easy-to-use, cutting-edge SQL Server client applications.
KeywordsClient Application Query Execution Visual Studio Query Plan Static Void
Unable to display preview. Download preview PDF.