public expences() { InitializeComponent(); //var db = new dbctx(); //financeaccounts = db.financeaccount.ToList(); var financeaccountrepo = new data.dapper.financeaccountrepo(); var financetransactionrepo = new data.dapper.financetransactionrepo(); financeaccounts = financeaccountrepo.get(); //var list = db.financetransaction.Where(a => (a.financeaccount.type == "expence")).ToList(); var list = financetransactionrepo.getmanybyfinanceaccounttype("expence"); foreach (var item in list) { dg.Items.Add(item); } var assetaccounts = financeaccounts.Where(a => a.type == "asset").ToList(); payingaccount_combobox.ItemsSource = assetaccounts; payingaccount_combobox.DisplayMemberPath = "name"; payingaccount_combobox.SelectedValuePath = "id"; var expenceaccounts = financeaccounts.Where(a => a.type == "expence").ToList(); expenceaccount_combobox.ItemsSource = expenceaccounts; expenceaccount_combobox.DisplayMemberPath = "name"; expenceaccount_combobox.SelectedValuePath = "id"; }