I readily admit that I am a bit of a novice developer (I work in a small business and we all help as much as possible). I came across the protocolbuf-net and it saved the day. We were not able to serialize our DataTable using .NET components because they were too large. But your stuff did the trick beautifully.
I need to register the protocolbuf-net dll with SQL CLR but I am getting an error and I am completely stumped. Hopefully you can help. I am running the following command in SQL Server 2008 R2: CREATE ASSEMBLY ProtobufNet FROM N'C:\Software\protobuf-net_r480\net20\protobuf-net.dll' WITH PERMISSION_SET = SAFE I get the following error: Msg 6218, Level 16, State 2, Line 1 CREATE ASSEMBLY for assembly 'protobuf-net' failed because assembly 'protobuf-net' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message [ : ProtoBuf.ProtoReader::ReadDouble][mdToken=0x6000232][offset 0x00000020][found address of Long] Expected numeric type on the stack. [ : ProtoBuf.ProtoReader::ReadSingle][mdToken=0x600023d][offset 0x00000018][found address of Int32] Expected numeric type on the stack. [ : ProtoBuf.ProtoWriter::WriteDouble][mdToken=0x600027f][offset 0x00000032][found address of Double] Expected numeric type on the stack. [ : ProtoBuf.ProtoWriter::WriteSingle][mdToken=0x6000280][offset 0x00000011][found address of Single] Expected numeric type on the stack. How do I get this DLL to register? The project is to create a SQL CLR stored procedure that executes a query into a DataTable and then serializes and compresses the results which are fed to a client which in turn decompresses and deserializes. I can get all the code to work without fail, but the DLL has to be registered with SQL and I have to register protobuf-net, too. Thanks in advance! -- You received this message because you are subscribed to the Google Groups "Protocol Buffers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/protobuf?hl=en.
