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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Returning SQLXml from CLR assembly fails when calling using ADO.NET

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

Currently I am calling as CLR function that returns SqlXML. The XML is over 4000 characters long and every time I issue the command from ADO.NET it keeps failing with the following Exception


A .NET Framework error occurred during execution of user-defined routine or aggregate \"Library.GetContentTypes\": \r\nSystem.NullReferenceException: Object reference not set to an instance of an object.\r\nSystem.NullReferenceException: \r\n   at System.Data.SqlServer.Internal.CClrLobContext.HManagedContext()\r\n   at System.Data.SqlServer.Internal.ClrLevelContext.GetCurrentContextForLobAccess(CClrLobContext* pLobContext)\r\n   at System.Data.SqlServer.Internal.ClrLevelContext.GetXvarXmlStream(CXVariantBase* pxvarSource, XvarLOBStreamInitCode eCode, CClrLobContext* pLobContext)\r\n.

The ADO.Net procedure looks like this 



Database db = CreateConnection();
      DbCommand dbCommand = db.GetStoredProcCommand("[dbo].[Library.GetContentTypes]");
      SqlParameter rv = new SqlParameter("@returnvalue", SqlDbType.Xml);
      rv.Direction = ParameterDirection.ReturnValue;

View Complete Post

More Related Resource Links

Error calling WCF service that is returning list.".Debugging resource strings are unavailable ......

Ok.this is just making me frustrated... Here is step by step of what I am trying to do (& not able to) 1. I am calling WCF service hosted in a SharePoint 2010 site from a silverlight app in same domain (So no cross doman I guess). 2. I use Linq to Sharepoint for querying the DB. 3. I am having a list "machines" in Sharepoint 2010 that is having a lookup column from Other list called "part" 4. My WCF method GetAllMachines() works perfectly well when it skips the lookup column "partname" & returns List of type machineitem. 5. But problem occurs when I add machineitemobject.parts.partsname in my Linq to Sharepoint query . My service gives the error not found Async_ExceptionOccurred] Arguments: Debugging resource strings are unavailable." 6. Note that return type of my Method is List<machinesitem> 7. The point to note here is that I use SPMETAL tool to generate the LINQ class that maps the lists . So When I try to query the lookup column it tries to add List item of the type class & that is what causing the error. Is it because I am not using datacontract in my service (but it returns the strings & all private members of machines list e.g. name,title etc) Is it making the attribute Serialisable will solve the error ??? I am kind of lost in it ...Plss help!!   Thanks

Calling Assembly in SSAS


Hi Experts,

Im using

While using the below MDX query im facing the below error.


select security_new.StoredProcedures.security_enc(1) on 0 from EncryptedCube

Executing the query ...
Execution of the managed stored procedure security_enc failed with the following error: Microsoft::AnalysisServices::AdomdServer::AdomdException.
The System.Data.SqlTypes.SqlInt32 type cannot be converted to an MDX type.

Dynamic Activity calling CLR Activity fails when Invoked?


MyActivity.xaml has a child activity, a CLR AsyncCodeActivity, SendMail.cs, dragged and dropped onto the 'root' activity which is a FlowChart.   SendMail.cs is in the same directory as MyActivity.xaml which is loaded dynamically like so:

    dynamicallyLoadedActivity = ActivityXamlServices.Load("("..\..\..\MyActivities\MyActivity.xaml");

At runtime, when WorkflowInvoker.Invoke(dynamicallyLoadedActivity ) is called, this exception is thrown:

    XamlObjectWriterException: Cannot create unknown type {"Cannot create unknown type '{clr-namespace:MyApp.MyActivities}SendEmail'."}

The imports on MyActivty.xaml include "MyApp"  xmlns:local="clr-namespace:MyApp.MyActivities"  and the xaml: <local:SendEmail .... looks OK.

Here is the top of the stack trace:

System.Xaml.XamlObjectWriterException was unhandled
  Message=Cannot create unknown type '{clr-namespace:MyApp.MyActivities}SendEmail'.
       at System.Xaml.XamlObjectWriter.WriteStartObject(XamlType xamlType)
       at System.Xaml.XamlWriter.WriteNode(XamlReader reader)

Assembly calling in MDX



  Any one pls tell me when i calling the Assemblyname.Classname.Functionname in MDX query im getting the following error.

"Execution of the managed stored procedure DecryptionSql failed with the following error: Exception has been thrown by the target of an invocation.The requested operation requires a SqlClr context, which is only available when running in the Sql Server process.."

Pls do help me to solve this issue.

Thanks in advance..



On Change:Prevent Evaluation fails with error Could not load file or assembly 'Microsoft.SqlServer.


Hi All,

I am facing a strange issue with Policy Based Management. Exact problem is as below

SQL Setups


I have Lenovo laptop having 3 SQL instances installed on it.

SQL Server 2005 (x86) Developer Edition 9.00.4053  -- Named Instance : SQL2K5

SQL Server 2008 (x86) Developer Edition 10.0.1600.22 -- Named Instance : SQL2K8

SQL Server 2008 R2 (x86) Developer Edition 10.50.1600.1 -- Named Instance : SQL2K8R2


I configured SQL2K8R2 instance as a Centralized Server and registed SQL2K8 & SQL2K5 under this. I configured a new condition by using facet: MULTIPART NAME. As per this condition Table Should start with TEST_ in database TEST . Evaluation Mode set to              On Change: Prevent. Idea is if some one logs to database TEST and tries to create table with name other then starting with TEST_ then it should fail.

I Imported this policy on registered servers thru Centralized Management Server Action, as expected policy got configured on Registred SQL2K8 instance

Service returning Object fails when object is complex class


Hi. I have created a WPF client and a self-hosted WCF Service based on an interface, in wich alle methods returns a standard response class. An example of one such method definition is:

Response CreateAccount(AccountCreationParams accountParams);


The response object is defined as:



public class Response



public string ResponseText;


public bool CompletedSuccesfully;



Is calling a .net 4.0 assembly possible from .net 2.0


Hi guys,

Can anyone tell me if its possible for a site or application that is running against .net 2.0 to call an assembly that was compiled using the 4.0 framework?

I always thought that this was possible, however when I try and add the reference to Visual Studio, I get an error saying that its not happy with the difference in versions.

Can anyone advise if there is a way to make this work?

Many thanks to anyone who can help

Best Regards


Verification of Calling Assembly




i want to ensure that using a method like "Encrypt()" in Assembly "crypter.dll" only returns the correct results if called from authorized programs/assemblies.

In detail i want to set up the following:


main.dll --> main assembly written in c# .NET containing all main application code

crypter.dll --> cryptographic assembly written in visual c++ to provide special cryptographic routines


Now i want ensure that only main.dll can p/invoke the methods provided by crypter.dll. I know strong names but by my understanding how they work

is that it's only a check if crypter.dll is equal to that version/public token which is referenced in main.dll.


Can i do some reflection from c++ to verify the public token/strong name of the main.dll calling method "MyCrypt()" and supply wrong data if called from third party assembly "3rdparty.dll"?


please let me know if i missed some mechanisms that already exist to do such things.



SQL Server 2008 R2 enterprise fails with assembly error.


I have been trying to install Sql Server 2008 R2 Enterprise Edition on a 64-bit Windows 7 real machine (not a VM). Every single time it fails when installing the setup support files, during the "ExecuteStandardTimingsWorkflow" action. This is the dialog that comes up:


"The following error has occured:

An error occured during the installation of assembly 'Microsoft.SqlServer.GridControl,fileversion="10.50.1600.1",version-"",culture="nuetral",publickeytoken="<number>",processArchitecture="x86". Please refer to Help and Support for more information. HRESULT: 0x80131047.


I have tried running the setup.exe from a 32-bit command prompt, and an elevated command prompt. I am logged in as a system administrator. I removed a version of SQL Server that was previously on the system sql server 2008. I also had rebooted before all of these installation attempts.

Web Services - Returning a Cookie from the web service im calling after authentication



I am trying to call an authentication method on a web service that returns a cookie, however when i call the web service, I just get the SOAP object returned, how do i get the cookie back after I have been authenticated ?

Any help or pointers appriciated

Kindest regards


Calling C# Assembly from SSIS Script Task


Hi All,


I am extracting very nasty file from our source. Before we used to run that file thru our C# sharp program and changed it to pipe delimited file. Then with then help of our in house ETL tool we load it to our staging table in SQL server.

Now  how to load that nastly file, then run C# sharp  and load into destination ( all in SSIS)?


Can we call that C-sharp program from SSIS?





SQL Server 2008 CLR Table-Valued function works exactly twice, then fails unless assembly reloaded.


Very simple TVF UDF uses WebRequest and HttpWebReponse, passing the response stream off to custom class that implements IEnumerable. First invocation has a good delay (seen many other posters on this issue), second invocation is lightening fast, then all calls after that produce this error:

Msg 6522, Level 16, State 1, Line 1
A .NET Framework error occurred during execution of user-defined routine or aggregate "tvf_OneMinuteBars":
System.Net.WebException: The operation has timed out
   at System.Net.HttpWebRequest.GetResponse()

Now, I've tried all manner of settings on the webrequest: KeepAlive, Timeout (currently 15 secs), Proxy = null. But I just can't figure it out. What is really a bummer is that I can debug invoke this against a local SQL Server as many times as I like. But if I deploy (in VS) to two different servers, or if I manually copy the assembly to the servers and do the CREATE ASSEMBLY / CREATE FUNCTION manually, it always times out after the second invocation.

Here is the tricky part: the object calling GetResponse calls HttpWebResponse.GetResponseStream(), storing the reference in a property. Then the object reference passed to the constructor of a custom class implementing IEnumerable, which does the right things with the response stream. Super fast, n

Returning a DataSet From a Web Services: Step-by-Step

This Example Shows how to create a webservice which returns a DataSet and a Client Which displays the DataSet in a Grid.


This Example Shows how to create a webservice which returns a DataSet and a Client Which displays the DataSet in a Grid.

Error: Encountered multiple versions of the same assembly with GUID...try pre-importing...TlbImp


Hi!  Can someone tell me how I can troubleshoot the following error: "Encountered multiple versions of the same assembly with GUID...try pre-importing one of these assemblies".

The website developed in VS 2010 (.Net 3.5). This error is only received on my workstation.  Another person developing the site does not experience this issue at all.  Also, not sure if this matters, but on my workstation the 'Assembly Information...' dialog contains no values even though the 'AssemblyInfo.vb' file does specify values for the title, desc, etc.  The GUID being referenced in the error is the main project of the three projects within the solution.

I tried looking through the GAC, but do not see any references to the projects or DLLs in the VS solution and am not sure what else/where to look.

If I delete the copy of the solution on my local machine and pull down a copy from source control (AnkhSVN) the solution will build with no error.  Once I make any changes, such as adding a new aspx file, then the error is received.

I can provide any additional information needed.

The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must



This is frustrating, and I don't know how to solve it.

I have a strange problem. I am adding a LinqDatasource object, and set the context:

        protected void LinqDataSource_ContextCreating(object sender, LinqDataSourceContextEventArgs e)
            e.ObjectInstance = new KaruselaDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

Then I get this error:
The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'.


On web.config I already have this:
<add assembly="System.Data.Linq, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.

is there another way adding a refernce to a web project? or only though teh web.config?


MySql.Data assembly problem



I added refernece MySql.Data to my project. My web.config looks like that:

<?xml version="1.0"?>
                <add assembly="MySql.Data, Version=, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>

But when in ServerExplorer I try "Add Connection..." I can't find "MySql Database" in the "Choose Data Source" dialog box?

What the problem can be?

Returning datas from two excel file



I used the below code to return the datas from one excel file. My question is if i suppose need to get the records from morethan one excel file using joins, how it is possible.

   string connString = ConfigurationManager.ConnectionStrings["xls"].ConnectionString;
        // Create the connection object 
        OleDbConnection oledbConn = new OleDbConnection(connString);
         // Open connection
            // Create OleDbCommand object and select data from worksheet Sheet1
            OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", oledbConn);
            // Create new OleDbDataAdapter 
            OleDbDataAdapter oleda = new OleDbDataAdapter();
            oleda.SelectCommand = cmd;
            // Create a DataSet which will hold the data extracted from the worksheet.
            DataSet ds = new DataSet();
            // Fill the DataSet from the data extracted from the worksheet.
            oleda.Fill(ds, "Employees");




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