Designing a data model in VS2010 and generating ORM code, application
- by Kay Zed
Simply put: I have a database design in my head and I now want to use Visual Studio 2010 to create a WPF application. Key is to use the VS2010 tools to take much as possible manual work out of my hands.
-The database engine is SQLite
-ORM probably through DBLINQ
-Use of LINQ
-The application can create new, empty database instances
-Easily maintainable (changes in data model possible)
Q- How do I start designing the database model (visually) in Visual Studio 2010? Should this be an xsd? Do I do this in a separate project?
Q- Next, how can I make the most use of VS2010 code generation tools to generate a business layer?
Q- I suppose the business layer will be added as a Data Source (in another project?) and from there it's a rather generic data binding solution?
I tried finding clear examples of this but it's a jungle out there, the hunt for a solution is NOT converging to one clear method.... :_(