Using CLR With SQL Server 2012

December 9th, 2013 | Posted by Vidya Vrat in .NET | C# | CLR | SQL Server - (0 Comments)

In this article, I’ll cover the following:

  • Introduction to SQL CLR
  • Choosing Between T-SQL and SQL CLR
  • Enabling SQL CLR Integration
  • Creating a SQL CLR Stored Procedure
  • Deploying a SQL CLR Stored Procedure into SQL Server
  • Executing the SQL CLR Stored Procedure

Introduction to SQL CLR
SQL CLR is a tiny version of the .NET CLR that is integrated into the SQL Server 2005 and onwards. The existence of CLR in SQL Server allows the C# programmers and other .NET compliant language programmers to write database specific business logic in a programming language like C# instead of T-SQL. Let’s understand what type of objects a programmer can create with SQL CLR integration. Read Full Article Here
The following are objects that can be created using SQL CLR:

  • The following types of database objects can be created with SQL CLR Integration:
  • Stored Procedures
  • User defined aggregates
  • Triggers
  • User defined types


TitleSlide - Evolution of CS.NET



 

 

 

 

 

 


 

 

 

.NET Code Access Security

August 6th, 2013 | Posted by Vidya Vrat in .NET | C# | CLR - (0 Comments)

Security is an essential part of an application and it should be taken into  consideration from the grass root level from an application’s design. Security  is all about protecting your assets from unauthorized actions.

But Code Access Security (CAS) is a feature of .NET CLR which enables you to  control the permissions which an individual .NET application have on your system  during its execution. As a developer, you must understand how to create  applications that work even when some permission is restricted or to restrict  your application to perform certain tasks for example, a user can’t  delete/create a file in C:\Windows directory Read Full Article Here

Article on Attributes with C# .NET

July 8th, 2013 | Posted by Vidya Vrat in .NET | C# | CLR - (0 Comments)

My latest article on “.NET Attributes” explains the Attributes and their usage with C#. It also refers to my previous articles where I have focused on specific attribute based topics for example, [CLSCompliant] and [WebMethod].

Read full article here on C# corner

Purpose of new Keyword

July 3rd, 2013 | Posted by Vidya Vrat in .NET | CLR - (0 Comments)

When you see such statement, one thing which comes in your mind about purpose of new keyword is that it creates an instance, isn’t it?

Class objC= new Class();

When this is certainly the main purpose, there are other behind the scene tasks, our well known new keyword is responsible for, lets understand what:

1-  Verifies the size needed for object allocation on managed heap.
2- If sufficient space is available then allocate the object, where application root pointer is pointing.
3- If required space is not available then, it triggers the GC (Garbage collection) lives in System.GC namespace, which does the heap cleanup and then after reclamation of needed space, the object will be allocated.

So, new is not just instance creation, its more that that. By the way, IL instruction for new is newobj.

Article on Multithreading with C# .NET

July 1st, 2013 | Posted by Vidya Vrat in .NET | C# | CLR - (0 Comments)

My latest article on Multithreading with C# .NET explains all you need to know to build successful enterprise applications.  This article emphasize on threading fundamentals, concepts, and techniques with code examples.

Read full article here on C# corner