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;
}
