September 7, 2008 11:38pm pdt

Member Login

Hall of Fame

Yearly

1jaime_oliv... 520,997
2TheLearn... 353,216
3jandromeda 240,713
4Fernando... 213,869
5JimBrandley 205,943
6p_davis 194,294
7angelIII 164,843
8Dhaest 157,837
9burakiewicz 147,113
10anarki_ji... 130,050
11naspinski 122,111
12ZachSmith 118,878
13ShazbotOK 107,960
14CyrexCor... 98,575
15jcoehoorn 96,435
16philipjonat... 91,424
17REA_AN... 88,770
18josgood 83,688
19gauthampj 81,948
20raterus 79,965
21margajet24 79,659
22junges 77,200
23GreenGho... 75,560
24monarch... 73,395
25emoreau 73,061

	[x] Attachment Details

CLR compile error SerializedDataWithMetadata

Zones: C# Programming Language, SQL Server 2005

HI,

I'm trying to compile a simple SQL CLR and have a compile error.

error CS0117: 'Microsoft.SqlServer.Server.Format' does not contain a definition for 'SerializedDataWithMetadata'

The problem is with the statement Format.SerializedDataWithMetadata. I have a feeling it's something to do with using the correct scope.

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:

           
           
             using System;
using System.Data.Sql;
using System.Data.SqlTypes;
using System.Data.SqlClient;
using System.Text;
using Microsoft.SqlServer.Server;
 
 
[Serializable]
[Microsoft.SqlServer.Server.SqlUserDefinedAggregate(Format.SerializedDataWithMetadata,
    MaxByteSize = 8000, IsInvariantToNulls = true,
    IsInvariantToDuplicates = false, IsInvariantToOrder = true,
    IsNullIfEmpty = true)]
 
public struct Concatenate
{
    private StringBuilder ReturnList;
    public void Init()
    {
        ReturnList = new StringBuilder();
    }
 
    public void Accumulate(SqlString Value)
    {
        if (Value.IsNull)
            return;
        ReturnList.Append(Value.ToString() + ", ");
    }
 
    public void Merge(Concatenate Group)
    {
        ReturnList.Append(Group.ReturnList.ToString() + ", ");
    }
 
    public SqlString Terminate()
    {
        if (ReturnList.ToString().Length == 0)
            return SqlString.Null;
        else
        {
            String s = ReturnList.ToString();
            SqlString ret = (SqlString) s.Substring(0, s.Length -2);
            ReturnList.Length = 0;
            return ret;
        }
    }
}

           
         

Start your free trial to view this solution

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.0

Question Stats

Zone: Programming

Question Asked By: sqlconsumer

Solution Provided By: sqlconsumer

Participating Experts: 1

Solution Grade: A

Translate:

Loading Advertisement...

20080723-EE-VQP-34 / EE_QW_2_20070628