Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Jay Natarajan, Rudi Bruchez, Scott Shaw, and Michael Coles
About this chapter
Cite this chapter
Natarajan, J., Bruchez, R., Shaw, S., Coles, M. (2012). .NET Client Programming. In: Pro T-SQL 2012 Programmer’s Guide. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4597-1_15
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4597-1_15
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4596-4
Online ISBN: 978-1-4302-4597-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books