SSRS Custom Assembly Using ADO.NET Entity Framework?
Hi, I am building a DLL to pull configuration settings from a database table using all the nice classes like ConfigurationSection, ConfigurationElement, ConfigurationElementCollection, etc ... I am wondering, to actually connect to and retrieve the data from the database, would using the ADO.NET Entity Framework objects in my DLL be too much trouble for SQL Server Reporting Services 2008? I know that I would at least have to migrate the configuration settings to a configuration file on the SSRS server. Then, perhaps read the configuration file into an XElement or XDocument and pass the settings somehow to the entity framework code that requires those settings. What else would be involved? Thank you! Dan
March 10th, 2011 8:22pm

Hi Dan, Create ADO.NET Data Services based on your EDM:http://geekswithblogs.net/frankw/archive/2008/03/08/ado.net-entity-framework-and-data-services-in-action-part-1.aspx For more information about How to: Implement Custom Data Class Interfaces (Entity Framework), please see: http://msdn.microsoft.com/en-us/library/bb738453(v=VS.90).aspx?appId=Dev10IDEF1&l=EN-US&k=k(SYSTEM.DATA.OBJECTS.DATACLASSES.ENTITYOBJECT.REPORTPROPERTYCHANGED);k(DevLang-CSHARP)&rd=true Hope this helps! Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
March 13th, 2011 11:32pm

Btw, please make sure to compile your custom assembly targetting .NET 3.5 to use it with Reporting Services 2008. Thanks, RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
March 14th, 2011 1:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics