Which is more important, an efficient database or a well-designed client application that connects to the database? In our 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 he or she uses to connect to your database is slow and unresponsive. While this book focuses on SQL Server server-side development functionality, we’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 2012 client connectivity simple and efficient. In this chapter, we will discuss using ADO.NET, and the .NET SqlClient as a basis for building your own easy-to-use, cutting-edge SQL Server client applications, and we will venture into modern ORM trends with LINQ to SQL and Entity Framework.
Unable to display preview. Download preview PDF.