public MainWindow() { InitializeComponent(); DataContext = this; var connection = new SQLiteAsyncConnection("chinook.db"); var dataSource = new SQLiteVirtualDataSource(); dataSource.Connection = connection; dataSource.TableExpression = "tracks left outer join albums on tracks.AlbumId = albums.AlbumId"; dataSource.ProjectionType = typeof(Track); DataSource = dataSource; }
public MainPage(string dbPath) { _connection = new SQLiteAsyncConnection(dbPath); InitializeComponent(); var dataSource = new SQLiteVirtualDataSource(); dataSource.Connection = _connection; dataSource.TableExpression = "tracks left outer join albums on tracks.AlbumId = albums.AlbumId"; dataSource.ProjectionType = typeof(Track); grid.ItemsSource = dataSource; }