CLR

Sort By Search Results

How To Create Four Types Of CLR Database Procedures In Visual Studio In C#Jun 01, 2018. In this article, we will learn about CLR database procedures in C#. Let’s discuss CLR database stored procedure.
An Overview Of CLR Database Procedures In C#May 31, 2018. In this article, we will learn about CLR database procedures in C#. Let’s discuss CLR database stored procedure.
Why CLR Database User Defined Scalar and Table Value FunctionMay 29, 2018. In this article, we will learn about CLR database user-defined scalar and table-valued function in C#
How To Create CLR Triggers In C# And Install And Uninstall CLR Assembly In MSSQL ServerMay 16, 2018. In this article, we will learn how to create CLR Triggers in C# and install & uninstall CLR assembly in MSSQL Server.
Create CLR Stored Procedure With And Without Namespace In C# And Install And Uninstall CLR Assembly In MSSQL ServerMay 13, 2018. In this article, we will learn how to create a CLR Stored Procedure with & without namespace in C# and install & uninstall CLR assembly in MSSQL Server.
Update SQL Server Data To SharePoint Using CLR Trigger And SharePoint Client Object ModelDec 24, 2016. In this article, you will learn how to update SQL Server data to SharePoint, using CLR Trigger and SharePoint Client Object Model.
.NET CLR Interview Questions and AnswersOct 23, 2015. In this article, we will go through the important .NET CLR Interview questions and answers.
Step-by-step Create CLR Stored ProcedureMar 26, 2015. In this article we will create a CLR stored procedure step by step.
Pass the Table Type Data to SQL CLR ObjectMar 19, 2015. In this article we will learn how to pass table type data to a SQL object.
Monitoring the Activities of Garbage Collection in .NET Using CLR ProfilerJan 05, 2015. In this article we learn about garbage collection and it's generations as well as how we can monitor it using the CLR Profiler.
Using CLR With SQL Server 2012Dec 08, 2013. In this article, I’ll cover the SQL CLR in SQL Server 2012.
SQL CLR For Beginners: Part 2: Create Trigger in SQL-CLR ProjectSep 01, 2013. In this article we will see how to create a simple trigger in a SQL-CLR project. I hope you are already quite familiar with the concept of triggers in SQL Server (or some other database).
SQL CLR For Beginners: Part 3: Create Function in SQL-CLRSep 01, 2013. In this article we will see how to create a simple function in a SQL-CLR Project.
SQL CLR For Beginners: Part 1: Create Store Procedure in SQL-CLR ProjectAug 29, 2013. In this article series, we will understand a few important concepts to develop projects in SQL Server CLR. Please don't be confused by the name SQL-CLR, It's nothing but a SQL Server CLR project. For the sake of simplicity, in this article we will call it SQL-CLR.
To Find Installed Version of .Net Framework Using CLR Version ToolJun 14, 2013. Learn about Clrver.exe utility to identify .NET Framework versions. Use MSCorEE.dll presence in system directories. Visual Studio command prompt access. View installed .NET versions and CLR versions used by processes. Enjoy this informative guide.
Table Valued CLR Function in SQL ServerAug 28, 2012. In SQL Server 2005 and later versions of it, database objects such as functions, Stored Procedures, etc. can be created which are already created in CLR.
Stored Procedure Using c# CLR ProjectMay 16, 2012. In this article you will learn how too create a Stored Procedure using a C# CLR Project.
Create Your First CLR Trigger in SQL Server 2008 Using C#May 05, 2011. CLR Trigger for SQL Server. Here you will see how to create your first CLR Trigger for SQL Server 2008 using C#.
Converting XML data to CLR object using XmlSerializerFeb 14, 2011. My last Post (Consuming Webservice from Silverlight) was all about accessing a web service/API from Silverlight; there I described how to consume an external API, with a sample from GeoName web services. As I said in that article, this article is the continuation. Here I am going to demonstrate how to convert the result output, which is in XML, to a CLR object and of course using it as a datasource in a Silverlight application.
Harnessing Regular Expressions in SQL Server using CLR IntegrationDec 02, 2010. This article discusses how to create a Regex library of CLR functions for SQL Server. CLR Integration is available in SQL Server 2005 and above.
Enabling CLR integration in SQL Server 2005Jul 31, 2006. One of the new features in SQL Server 2005 is the feature to write your own stored procedures using any language supported in .NET. This feature gives you more flexibility to implement any complex logic in your business scenario.
.NET Performance Counters, Part 1: Predefined CLR Performance CountersMay 13, 2002. In this article, I will describe what a performance counter is and introduce you to the predefined counters that you can use to monitor the state of the CLR while your applications run.
Exploring The Key Components Of .NET - CLR, CTS, And CLSApr 06, 2023. The article explores the three key components of the .NET Framework: the Common Language Runtime (CLR), Common Type System (CTS), and CLS
Calling REST API Service From SQL Server Using C# SQL CLRFeb 11, 2020. A requirement where we need to get data from other sources (REST-based Web Service) and sync with on-premises (local) database. This should be done using a SQL Server Stored Procedure.
CLR Stored Procedures in SQL ServerMar 12, 2015. In this article, we will learn about CLR Stored Procedures in SQL server.
What is Common Language Runtime (CLR)Feb 25, 2014. Common Language Runtime (CLR) is one of the key components of .NET. Learn what is CLR in .NET and C#.
SQL-CLR For Beginners: Part-5: Call Function and Procedure From Other ProcedureSep 20, 2013. In today’s article, we will learn how to call store procedure and user-defined function ( UDF in Database) from store procedure.
SQL-CLR For Beginners: Part-4: Consume C# Class in Stored ProcedureSep 04, 2013. In this article we will learn how to use traditional C# class within SQL-CLR Application.
CLR Internals - Process and Application DomainMay 28, 2013. In this article, you‘ll drill deeper into the details of how an assembly is hosted by the CLR and come to understand the relationship between application domain (appdomain) and processes.
What is CLI and CLRFeb 07, 2013. This part gives a basic introduction to CLI, Components of CLI, CLR and Features of CLR.
CLR Function in SQL Server Aug 27, 2012. In SQL Server 2005 and later version of it, database objects like function, store Procedure, etc can be created which are already created in CLR.
CLR Object And JSON Serialization And DeserializationAug 27, 2012. This article demonstrates how to serialize and deserialize CLR objects for web-based applications.
CLR Execution ProcessApr 13, 2011. Here you will see CLR Execution Process. The CLR which is the runtime environment for .Net, provides services such as Memory Management, Security Management, Exception Handling, and Cross language Integration.
SQLCLR vs. T-SQL - Performance ComparisonDec 09, 2010. Before comparing the performance of SQLCLR and TSQL, just have a quick at the definition of SQLCLR.
CLR Object Binding In WPFJul 27, 2009. This article explains about one of the binding concept in WPF.
SQLCLR DebuggingNov 10, 2005. In SQL Server 2005, CLR integration allows you to write stored procedures, triggers, user-defined types, and user-defined functions using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#. In this article, I will explain how to debug SQLCLR stored procedure or SQLCLR user-defined function.
Building Managed Code Using Common Language Runtime (CLR) Integration in SQL Server 2005Oct 24, 2005. In this article I am going to talk about a cool new feature of SQL Server 2005 called CLR Integration, its advantages and how to program database objects using managed code with a simple project in Visual Studio 2005 beta 2.
SQLCLR DebuggingAug 09, 2005. In SQL Server 2005, CLR integration allows you to write stored procedures, triggers, user-defined types, and user-defined functions using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#. In this article, I will explain how to debug SQLCLR stored procedure or SQLCLR user-defined function.
IL "The Language of CLR" - A Platform for Cross-LanguageJun 28, 2001. This article introduces the Cross-Language capabilities of CLR environment (Common Language Runtime Environment) and its constituent language IL (Intermediate Language).

OUR TRAINING