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: 588

Filed under:

wpf

|

visual-studio-2010

|

sqlite

|

database

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

C#/WPF - RoutedEvent in WPF class that isn't a UIElement

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a class that needs to notify that something significant has occured. The class is in a WPF-project, even though this specific class, is lookless (and doesn't inherit from UIElement, neither directly or indirectly). Normally, I just register a RoutedEvent to get this functionality but as this… >>> More
How to pass value from wpf form to wpf user control

as seen on Stack Overflow - Search for 'Stack Overflow'
Hai am having a WPF user control in my WPF Form, when i click my button in my form , i just want to pass some value to the textbox which is in the usercontrol, tell me how to do this. >>> More
WPF opening up exe program within WPF window

as seen on Stack Overflow - Search for 'Stack Overflow'
Not sure if this is possible but is there a way to open up another program like notepad within the container of a WPF window? similiar to that of being able to open a web page using the webbrowser control? Basically I would like to open notepad or other exe but keep it constrained within the WPF… >>> More
Silverlight Commands Hacks: Passing EventArgs as CommandParameter to DelegateCommand triggered by Ev

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Today I've tried to find a way how to pass EventArgs as CommandParameter to DelegateCommand triggered by EventTrigger. By reverse engineering of default InvokeCommandAction I find that blend team just ignores event args.To resolve this issue I have created my own action for triggering delegate commands… >>> More
Building applications with WPF, MVVM and Prism(aka CAG)

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
In this article I am going to walk through an application using WPF and Prism (aka composite application guidance, CAG) which simulates engaging a taxi (cab). The rules are simple, the app would have3 screens A login screen to authenticate the user An information screen. A screen… >>> More

Related posts about visual-studio-2010

La version gratuite de Visual Studio 2010 est disponible, Visual Studio 2010 Express introduit des o

as seen on Developper.com - Search for 'Developper.com'
Visual Studio 2010 Express est disponible La version gratuite de Visual Studio 2010 propose à présent des outils de développement pour Windows Phone 7 Alors que Visual Studio 2010 débarque avec ses nouveautés (lire par ailleurs ici), sa version gratuite Visual Studio Express 2010 vient d'être… >>> More
Are Visual Studio 2010 Professional Solutions/Projects 100% compatible with Visual Studio 2010 Premi

as seen on Stack Overflow - Search for 'Stack Overflow'
I am just wondering on what version of Visual Studio 2010 to install (Professional or Premium) If there are a few people in the team with a mix of VS2010 professional/premium, would opening solution/project files be an issue, ie incorrect version or prompts to upgrade prjects.. Projects include:… >>> More
[ASP.NET 4.0] Persisting Row Selection in Data Controls

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Data Control Selection Feature In ASP.NET 2.0: ASP.NET Data Controls row selection feature was based on row index (in the current page), this of course produce an issue if you try to select an item in the first page then navigate to the second page without select any record you will find the same… >>> More
Entity Framework Code-First to Provide Replacement for ASP.NET Profile Provider

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
A while back, I coordinated a project to add support for the SQL Table Profile Provider in ASP.NET 4 Web Applications. We urged Microsoft to improve ASP.NET’s built-in Profile support so our workaround wouldn’t be necessary. Instead, Microsoft plans to provide a replacement for ASP.NET Profile… >>> More
Tip#102: Did you know… How to specify tag specific formatting

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Let’s see this with an example. I have the following html code on my page. Now if I format the document by selecting Edit –> Format document (or Ctrl K, Ctrl D) The document becomes I want the content inside td should remain on the same line Read More......(read more) >>> More