Paulo Morgado

Playing With SQL Server CLR Integration – Part III

You might have noticed that I used LINQ in my last Playing With SQL Server CLR Integration posts ( Part I , Part II ). I couldn’t make it work with the standard Visual Studio 2008 SQL CLR project template. Changing the Target Framework to .NET Framework...

Playing With SQL Server CLR Integration – Part II

On my last post , I showed how to convert a property bag stored in text to a CLR Table-Valued Function . I started thinking that I could retrieve the property values, but I couldn’t change them or add new properties. Passing a table as a parameter is...

Playing With SQL Server CLR Integration – Part I

I’m currently working with an application that stores a property bag in a SQL Server column like this: [[[name1]]] value1 [[[name2]]] value2.1 value2.2 [[[name3]]] value3 Don’t ask me why it’s done like this. It just is. The application decodes this property...

Microsoft Releases SQL Server 2008

SQL Server 2008 is finally out and comes with the Entity Framework , which means that SP1 for Visual Studio 2008 and the .NET Framework is almost out.