Dapper Tutorial - Knowledge Base (KB)

How do you bind Dapper query result to WPF DataGrid

Here's my code. It produces a bound grid with the correct number of rows, however the ...cells are empty.......XAML...<DataGrid Name="grid" ItemsSource="{Binding}" AutoGenerateColumns="True" /> ...Code behind...grid.DataContext = cn.Query("select *...

Filling and binding two combobox WPF Caliburn.micro

I have this table: ...I use in my project this view Called NewItem and in this view there is two combobox. ...I would like to do this : that in the combobox Group there are all DESCRIPTION of table GROUP, and when i choose an item of this description (of...

Application Migration to Dapper.net from EF4

I am working on a large WPF application with Entity framework4 now client is asking to migrate application from EF4 to Dapper.net. I am not sure about feasibility & business gain of this migration task as following features of EF4 are missing in Dapper:..

Map lists of nested objects with Dapper

I'm using Dapper and I have classes like this:...public class Article{ public int Id { get; set; } public string Description{get;set;} public Group Group { get; set; } public List<Barcode> Barcode {get;set;} ... } public class Group{ pu...

Inserting with Dapper.Contrib and DynamicParameters

QUESTION :...Is there a clever way to dynamically add parameters to an object and insert them in to a SQL DB?...preferably using Dapper...I'm writing a WPF app where (amongest other things) I'm collecting questionnaire data. I'm using Dapper to map c# obj...

Dapper fails with .net 4.6 - Could not load file or assembly

I have a WPF / MVVM Light application targeting .net 4.6 and Dapper 1.50.4 I am using Visual Studio Pro 2017 to develop the application...This application was working, but I got a new computer and moved the development of this application to the new compu...

How do I distinguish the new rows in a datagrid from the existing ones?

I have an ordinary DataGrid in a WPF application that is backed by an ...ObservableCollection<T>.... I am updating a SQL Server database using Dapper....Dapper can update existing records without problems, but to get new records into the database I have ...

Retrieving data from a database in the background while a dialog is loading

I'm using Dapper in a WPF application to retrieve data from a database for a couple of combobox lists. I'd like that retrieval to occur in the background; it will prevent a small delay when the user opens the first combo box....So I've done this:...priva...

ItemSource/DataSource for TextBlock

I'm using dapper to retrieve some data from a database using a list. I've been able to do it with a ListBox using...private void UpdateBinding() { displayLastNameLB.ItemsSource = people; displayLastNameLB.DisplayMemberPath = "FullInfo"; } ...and n...

WPF, Caliburn Micro and Dapper - Datagrid Checkbox binding

I am using Caliburn Micro and Dapper in a WPF Project where I create a ...DataGrid... which I populate with data from a SQL Server Database Table. Please consider the following code snippets:...ChangesModel.cs...using System; using System.Collections.Gene...

How can I update my XAML when I change currentUser via viewmodel?

I am creating my first 'bigger' WPF application, and I had something like tinder in mind. I already have created a card which looks like this: ...Result...It shows the first user that is in my database. My goal is when I click on the right (next) or left ...