Using WPF MVVM for Database Access

Doug Wyrembek

Rate me:

4.97/5 (31 votes)

2 Nov 2010CPOL13 min read

211.3K

27.2K

113

An example of a WPF MVVM utility accessing a simple legacy database.

productmvvm.zip
- ProductMvvm
  - CreateStoredb.sql
  - ProductMvvm.sln
  - ProductMvvm
    - app.config
    - App.xaml
    - App.xaml.cs
    - bin
      - Release
        
        ProductMvvm.exe
        
        ProductMvvm.exe.config
        
        ProductMvvm.vshost.exe
        
        ProductMvvm.vshost.exe.config
        
        ProductMvvm.vshost.exe.manifest
    - ClassDiagram1.cd
    - ClassDiagram2.cd
    - Foundation
      - CommandBehavior.cs
      - Messenger.cs
      - RelayCommand.cs
    - GelButtonResourceDictionary.xaml
    - LightBrushedx.jpg
    - Linq.dbml
    - Linq.dbml.layout
    - Linq.designer.cs
    - Model
      - StoreDB.cs
    - ProductMvvm.csproj
    - ProductMvvm.csproj.user
    - Properties
      - AssemblyInfo.cs
      - Resources.Designer.cs
      - Resources.resx
      - Settings.Designer.cs
      - Settings.settings
    - Resource1.Designer.cs
    - Resource1.resx
    - ViewModels
      - Product.cs
      - ProductDisplayModel.cs
      - ProductDisplayModelStatus.cs
      - ProductSelectionModel.cs
    - Views
      - ProductDisplay.xaml
      - ProductDisplay.xaml.cs
      - ProductSelectionView.xaml
      - ProductSelectionView.xaml.cs
    - Window1.xaml
    - Window1.xaml.cs
productmvvmexe.zip
- ProductMvvmExe
  - CreateStoredb.sql
  - ProductMvvm.exe
  - ProductMvvm.exe.config

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
        <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >
            <section name="ProductMvvm.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />
        </sectionGroup>
    </configSections>
    <connectionStrings>
        <add name="ProductMvvm.Properties.Settings.xstoredbConnectionString"
            connectionString="Data Source=DOUG-PC;Initial Catalog=xstoredb;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
    <userSettings>
        <ProductMvvm.Properties.Settings>
            <setting name="StoreDBConnString" serializeAs="String">
                <value>Server=Doug-PC;Database=xstoreDB;Trusted_Connection=True;</value>
            </setting>
        </ProductMvvm.Properties.Settings>
    </userSettings>
</configuration>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Doug Wyrembek

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Using WPF MVVM for Database Access

License

Comments and Discussions