I should say i was able to create a retargeted DB project that deploys successfuly to my DB. I dont have access to the libraries i need to use extention methods. Also the DLINQ mapping tool is missing. Are there plabs to integrate this into the db
ps - As an alternative, Is there a way to add assemblies to the 'trusted' set of assemblies that are part of the sql server CLR integration
unfortunately, types in the linq dlls cant be added to sql server so although we can use all the new language features none of the extension methods are available.
Database projects
mdegi
I should say i was able to create a retargeted DB project that deploys successfuly to my DB. I dont have access to the libraries i need to use extention methods. Also the DLINQ mapping tool is missing. Are there plabs to integrate this into the db
ps - As an alternative, Is there a way to add assemblies to the 'trusted' set of assemblies that are part of the sql server CLR integration
GreyWolf
tomk_vsts_user
The topic of SQL - CLR comes up from time to time. It was asked several times at PDC and subsequent (see for instance a recent DLINQ chat: http://msdn.microsoft.com/chats/transcripts/vstudio/06_0323_msdn_dlinq.aspx). The official word is "the SQL team is looking at it".
It would seem that you would just need to add the appropriate references and custom build actions, but I may be missing something else as well.
Jim Wooley
http://devauthority.com/blogs/jwooley/default.aspx