Differences between revisions 1 and 8 (spanning 7 versions)
⇤ ← Revision 1 as of 2021-02-22 02:53:02 →
Size: 1563
Editor: scot
Comment:
← Revision 8 as of 2021-03-17 22:19:02 → ⇥
Size: 1687
Editor: scot
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
= Directions for 2/22/2021 CPTR 319 = = Example WPF project using C# .NET Core 3.1 =
Line 3: Line 3:
Create a .NET Core WPF application
Create a folder in the project called "Database"
Add the BibleBeliefs.DB file to the new "Database" folder.
Set the file to be copied to the output folder if newer.		 Getting Started:

 * Create a .NET Core WPF application
 * Create a folder in the project called "Database"
 * Add the [[attachment:BibleBeliefs.db|BibleBeliefs.DB]] file to the new "Database" folder.
 * Set the file to be copied to the output folder if newer.
Line 10: Line 12:
 * Microsoft.EntityFrameworkCore
 * Microsoft.EntityFrameworkCore.Sqlite
 * Microsoft.EntityFrameworkCore.Tools		  * Microsoft.!EntityFrameworkCore
 * Microsoft.!EntityFrameworkCore.Sqlite
 * Microsoft.!EntityFrameworkCore.Tools
Line 22: Line 24:
{{{#!highlight xml
Line 23: Line 26:
}}}

Add the Data Context

Example WPF project using C# .NET Core 3.1

Getting Started:

  • Create a .NET Core WPF application
  • Create a folder in the project called "Database"

  • Add the BibleBeliefs.DB file to the new "Database" folder.

  • Set the file to be copied to the output folder if newer.

Add the following nuget packages:

  • Microsoft.EntityFrameworkCore

  • Microsoft.EntityFrameworkCore.Sqlite

  • Microsoft.EntityFrameworkCore.Tools 

PM> Scaffold-DbContext "DataSource=.\DataBase\BibleBeliefs.db;" Microsoft.EntityFrameworkCore.SQLite -OutputDir "Database" -ContextDir "Database"

Add a Data Context to the xaml

Add a namespace for the ViewModels directory

Toggle line numbers 
   1 xmlns:viewmodels="clr-namespace:BibleBeliefs.ViewModels"

Add the Data Context

Toggle line numbers 
   1 <Window.DataContext>
   2      <viewmodels:MainViewModel/>
   3 </Window.DataContext>

Adding Data to the application

Now add the Grid

Toggle line numbers 
   1     <Grid>
   2         <Grid.ColumnDefinitions>
   3             <ColumnDefinition Width="250" />
   4             <ColumnDefinition Width="*" />
   5         </Grid.ColumnDefinitions>
   6         <Grid.RowDefinitions>
   7             <RowDefinition />
   8         </Grid.RowDefinitions>
   9         <DataGrid Grid.Row="0" Grid.Column="0" 
  10                   ItemsSource="{Binding Topics}" 
  11                   AutoGenerateColumns="False" 
  12                   SelectedItem="{Binding SelectedTopic}">
  13             <DataGrid.Columns>
  14                 <DataGridTextColumn Header="Topic" Binding="{Binding Topic}"  Width="*"/>
  15             </DataGrid.Columns>
  16         </DataGrid>
  17     </Grid>

ProgrammingLinks/WpfDatabaseExample2021 (last edited 2022-02-20 19:44:27 by scot)