Last post Feb 13, 2010 12:51 AM by danludwig
Feb 12, 2010 02:46 PM|jijo_robert|LINK
I am starting a new project in ASP.NET (With silverlight) - I would like to get expert opinion about how to design the data access.
I can use DataAccess Layer with SQL helper, but the challenge is every new field that I add needs to be added in the sql helper.
I am trying to see if there is a way to design the system, so that it appears in the front end when a new field is added. I don't want to have in the ASPX files (binding in controls) I want to have ability to change items in code.
Essentially I am trying to see the best option to have a database application.
Feb 13, 2010 12:51 AM|danludwig|LINK
I highly recommend using an ADO.NET EntityDataModel (.edmx file) for your data access layer. However, you can only use it with .NET version 3.5 and above.
Having a new field added to the database automatically appear in the front end is what is referred to as DynamicData. If your project is a web site, I would suggest trying out a DynamicDataEntities web site.
Good luck with your project.