public  delegate DataTable loadDataTable();DataTable shops = (cmbShop.Text == All Shops) ?       new loadDataTable(() =>       {       Program.con.GET_Table_From_DataBase(sh, select * from shops );       return Program.con.dst.Tables[sh];       }      ).Invoke()     :       new loadDataTable(() =>       {        Program.con.GET_Table_From_DataBase(sh, select * from shops where shopname=' +  cmbShop.Text + ' );        return Program.con.dst.Tables[sh];       }  ).Invoke();I am just setting the value of DataTable shops here.I am learning about lambda expressions, so just for learning purposes, I want to know if this code can be shortened while using lambda expressions.
Loading either all shops or a specifically named shop from a DataTable
c#;linq
You don't need any lambda expressions at all.You can writeif (cmbShop.Text == All Shops)    Program.con.GET_Table_From_DataBase(sh, select * from shops );else    Program.con.GET_Table_From_DataBase(sh, select * from shops where shopname=' +  cmbShop.Text + ' );DataTable shops = Program.con.dst.Tables[sh];