SQL Server Managed Code Error 'system.core.... was not found in the SQL catalog'

Hi Experts,
I wrote a SP in C# to deploy to SQL Server using VS2008.  The code works fine when I use it in windows app.  But when I push put into C# SP it generates the following error:
Error      1      Assembly 'system.core, version=, culture=neutral, publickeytoken=b77a5c561934e089.' was not found in the SQL catalog.      

Error      2      'System.Array' does not contain a definition for 'Count' and no extension method 'Count' accepting a first argument of type 'System.Array' could be found (are you missing a using directive or an assembly reference?)      

I have found several links to adding registering System.Core, adding references, etc.  but so far I have been unable to resolve the issue.  I 'think' it has to do with only 13 or so assemblies installed in SQL Server 2005.  Is there a way to add more references?





NOTE: When I comment out everything between the drConflicts.Count() == 0 and the end it still gives the errors, when I comment out the if/end then the error goes away.  I am assuming System.array which is not part of the assemblies in SQL Server is the problem?

Thanks in advance your help!
            DataRow[] dRow = dtInRunning.Select("plCallPID = " + pidID);
            DataRow[] drConflicts = dtConflict.Select("pdID = " + pidID);
            if (drConflicts.Count() == 0)
                if (dRow.Count() > 0)
                    pidRunningThreadQty = (Int32)dRow[0]["pidCnt"];
                    pidRunningThreadAllowed = (Int32)dRow[0]["pdPIDThreads"];
                    pidRunningClassQty = (Int32)dRow[0]["classCnt"];
                    pidRunningClassAllowed = (Int32)dRow[0]["pdClassThreads"];
                    pidMaxCallsPerDayAllowed = (Int32)dRow[0]["pdMaxCalls"];
                    if (pidRunningThreadQty >= pidRunningThreadAllowed)
                    { runPID = false; }
                    if (pidRunningClassQty >= pidRunningClassAllowed)
                    { runPID = false; }
                    //if (pidMaxCallsPerDayQty >= pidMaxCallsPerDayAllowed)
                    //{ runPID = false; }
                runPID = false;
            }  // if (drConflicts.Count(....

Open in new window

Who is Participating?
Eugene ZConnect With a Mentor Commented:
did you install .net framework 3.5
and all SW service packs

can you try to do it on VS2005?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.