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