SQL Server Home
Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper now INTERNAL
as By Design
4/6/2010 8:35:58 AM
User(s) can reproduce this bug
Hi I have a requirement to apply security filtering (column and row level) above and beyond the capabilities of SSRS Model security. in 2005 and 2008 I achieved this by creating a data Extension and tweaking the Command text and execute reader methods, and all was Well with the world. Now all I wanted was a bit of customisation of the SQL data Extension (SQL Connection Wrapper)... of course its Sealed so couldn't inherit, so I composite / wrapped it... and all was well with the world...... Now along comes SQL2008 R2 .... and someone has discovered the internal Keyword ! now everything is locked down. the Constructor of SQL Connection Wrapper is internal Luckily my code is not yet producion code, and I know Microsoft are completely within their rights ... but why ... all is not good with the world.
Any suggestions how to implement a minor customisation to SQL data Extension, without reimplementing the whole of the dataExtensions DLL !
Any chance the decison might be reversed ?
SQL Server 2008 R2 November CTP
Windows 7 Enterprise
Operating System Language
Steps to Reproduce
create a Data Extension
try to call Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper ctor
ctor is Internal
ctor public in all previous versions
to post a comment.
Please enter a comment.
on 8/17/2010 at 1:22 PM
We are closing the issue on our side.
Feel free to file a new connect item or re-activate this one if you have further questions.
on 8/9/2010 at 12:25 PM
Thanks for filing the issue. The SQL extension is internal data extension and is changed to internal in KJ. If customization is needed, you will need to implement a new data extension. There is no other way to achieve this.
Please let us know if you have further questions.
on 8/1/2010 at 7:13 AM
on 8/1/2010 at 7:00 AM
Resolved?? how? why no comments?
to post a workaround.
Please enter a workaround.
© 2014 Microsoft