Designing a data model in VS2010 and generating ORM code, application

Posted by Kay Zed on Stack Overflow See other posts from Stack Overflow or by Kay Zed
Published on 2010-05-19T15:03:34Z Indexed on 2010/05/19 23:30 UTC
Read the original article Hit count: 615

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.... :_(

© Stack Overflow or respective owner

Related posts about wpf

Related posts about visual-studio-2010