Click here to Skip to main content
15,880,427 members
Articles / Database Development / SQL Server

Implementing a CLR Stored Procedure in a LINQ based n-tier architecture

Rate me:
Please Sign up or sign in to vote.
4.85/5 (7 votes)
9 Sep 2009CPOL13 min read 43.3K   1.1K   40  
CLR Stored Procedures can be efficiently implemented in an n-tier architecture.
using System.Reflection;
using System.Runtime.CompilerServices;
using System.Runtime.InteropServices;
using System.Data.Sql;

// General Information about an assembly is controlled through the following
// set of attributes. Change these attribute values to modify the information
// associated with an assembly.
[assembly: AssemblyTitle("ClrStoredProcedureLayer")]
[assembly: AssemblyDescription("")]
[assembly: AssemblyConfiguration("")]
[assembly: AssemblyCompany("")]
[assembly: AssemblyProduct("ClrStoredProcedureLayer")]
[assembly: AssemblyCopyright("Copyright ©  2009")]
[assembly: AssemblyTrademark("")]
[assembly: AssemblyCulture("")]

[assembly: ComVisible(false)]

//
// Version information for an assembly consists of the following four values:
//
//      Major Version
//      Minor Version
//      Build Number
//      Revision
//
// You can specify all the values or you can default the Revision and Build Numbers
// by using the '*' as shown below:
[assembly: AssemblyVersion("1.0.*")]

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Product Manager
Denmark Denmark
A passionate techno-functional IT Executive with a total of 18+ years of experience in Delivery Head, Project/Product Management, Consulting, Development, R&D, and Delivery of enterprise global IT & Software solutions across multiple domains.

Spent 6+ years as a Program Director and 11+ years in core leadership, strategic planning & implementation, creating high-performance teams.

As a Co-founder and CTO at Xporium.com - one of the pioneer 3D virtual exhibition and digital connection platforms.

Directs and optimizes processes for evaluating alternate technologies while supervising and monitoring various IT and technology departments across the various spectrum for SDLC using various management models including waterfall, SCRUM, Agile, and Extreme Programming.

Heads large and complex projects at PMO and taking care of activities including but not limited to budgeting, funding, planning, personnel & resource allocation, risk and conflicts management, stakeholder management, and closures.

Currently working in cutting edge technologies including Quantum Computing, Artificial Intelligence and Machine Learning where I specifically love Computer Vision. I am a 2X Kaggle Expert.

He believes in "Perfection matters". He enjoys teaching people. When not working, Virat likes to swim and sleep.

Comments and Discussions