Differences between revisions 3 and 6 (spanning 3 versions)
⇤ ← Revision 3 as of 2021-02-22 02:54:54 →
Size: 1649
Editor: scot
Comment:
← Revision 6 as of 2021-02-22 15:17:01 → ⇥
Size: 1679
Editor: scot
Comment:
Deletions are marked like this. Additions are marked like this.
Line 7: Line 7:
 * Add the !BibleBeliefs.DB file to the new "Database" folder.    * Add the [[attachment:BibleBeliefs.db|!BibleBeliefs.DB]] file to the new "Database" folder.

Directions for 2/22/2021 CPTR 319

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)