Creating Database Objects in Managed Code
by Mike Snell, Lars Powers
Microsoft Visual Studio 2015 Unleashed, Third Edition
- About This eBook
- Title Page
- Copyright Page
- Contents at a Glance
- Table of Contents
- About the Authors
- Dedication
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction
- Part I: Introducing Visual Studio 2015
- Chapter 1. A Quick Tour of Visual Studio 2015
- Chapter 2. The Visual Studio IDE
- Chapter 3. The .NET Languages
- What’s New in C# 6.0 and VB 14
- Language Primer
- Language Features
- Infer a Variable’s Data Type Based on Assignment
- Create an Object and Initialize Its Values (Object Initializers)
- Define a Collection and Initialize Its Values
- Creating an Instance of a Nonexistent Class
- Add Methods to Existing Classes (Extension Methods)
- Add Business Logic to Generated Code (Partial Methods)
- Access and Query Data Using the .NET Languages
- Write Simple Unnamed Functions Within Your Code (Lambda Expressions)
- Splitting an Assembly Across Multiple Files
- Working with XML Directly Within Your Code (VB Only)
- Removing Unused Arguments from Event Handlers (VB Only)
- Creating an Automatically Implemented Property
- Dropping the Underscore in VB for Line Continuation
- Working with Dynamic Languages/Objects
- Covariance and Contravariance
- Asynchronous Programming
- The .NET Framework
- Summary
- Part II: An In-Depth Look at the IDE
- Chapter 4. Solutions and Projects
- Chapter 5. Browsers and Explorers
- Chapter 6. Introducing the Editors and Designers
- Part III: Working with the Visual Studio Tools
- Chapter 7. Working with Visual Studio’s Productivity Aids
- Chapter 8. Testing Code
- Chapter 9. Refactoring Code
- Chapter 10. Debugging Code
- Chapter 11. Deploying Code
- Chapter 12. Developing Applications in the Cloud with Windows Azure
- Chapter 13. Working with Databases
- Part IV: Extending Visual Studio
- Part V: Building Web Applications
- Chapter 17. Building Modern Websites with ASP.NET 5
- Chapter 18. Using JavaScript and Client-Side Frameworks
- Chapter 19. Building and Consuming Services with Web API and WCF
- Part VI: Building Windows Client Apps
- Chapter 20. Building Windows Forms Applications
- Chapter 21. Building WPF Applications
- Chapter 22. Developing Office Business Applications
- Part VII: Creating Mobile Apps
- Chapter 23. Developing Windows Store Applications
- Chapter 24. Creating Windows Phone Applications
- Chapter 25. Writing Cross-Platform Mobile Applications with Apache Cordova
- Index
- Code Snippets
Creating Database Objects in Managed Code
Database objects are commonly implemented using some dialect of the SQL language. This is true with SQL Server as well, and as we have just reviewed, the Visual Studio database project allows you to craft your database objects using SQL. But using that same project, you can also design database objects using C#.
SQL Server 2005 introduced the capability of authoring SQL objects in managed code. So, instead of using Transact SQL, you can actually write your stored procedures, queries, views, and so on using C#. These are run under the auspices of SQL Server’s own version of the .NET Common Language Runtime (CLR).
The SQL Server CLR supports a variety of object types that can be written in C#:
Stored procedures
Triggers
Aggregates
User-defined functions
User-defined types
The following sections look at how to go about creating a straightforward stored procedure using C# instead of T-SQL.
-
No Comment