.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

SQL CLR

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
 
Hi,   I am trying to invoke WCF service from SQL and regarding that i found we could do that by using SQL CLR. So i have created a small WCF Service and got it's reference in SQL project and compile it in .dll; now i am writing a SQL script to create the T-SQL wrapper function around your WCF call of the compiled SQL project dll and for that i am writing the following script use master; go sp_configure 'clr enabled', 1 go reconfigure go use [TestDB]; go alter database [TestDB] set trustworthy on; go --------------------------------------------------------------------- IF  EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'SMDiagnostics')     DROP ASSEMBLY [SMDiagnostics] GO IF  EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'System.Web')     DROP ASSEMBLY [System.Web] GO IF  EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'System.Messaging')     DROP ASSEMBLY [System.Messaging] GO IF  EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'System.ServiceModel')     DROP ASSEMBLY [System.ServiceModel] GO IF  EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'WcfServiceSQLCLR')     DROP ASSEMBLY [WcfServiceSQLCLR] GO IF  EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'SqlServerPr


View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend