static void Main(string[] args) { try { //first CustomerContainer ctx = new CustomerContainer(); try { var q = from c in ctx.CUSTOMERS select c; List<CUSTOMER> CustList = q.ToList(); foreach (CUSTOMER item in CustList) { Console.WriteLine(item.FNAME); } } catch (Exception e) { Console.WriteLine(e.Message); } // second ( multi-value) CustomerContainer ctx2 = new CustomerContainer(); try { var result = ctx2.ExecuteStoreQuery<CUSTOMER_MV>("SELECT * FROM UNNEST CUSTOMER ON ORDERS"); List<CUSTOMER_MV> CustList = result.ToList(); foreach (CUSTOMER_MV item in CustList) { Console.WriteLine(item.FNAME); } } catch (Exception e2) { Console.WriteLine(e2.Message); } } catch (Exception e3) { Console.WriteLine(e3.Message); } finally { Console.WriteLine("Enter to exit:"); string line = Console.ReadLine(); } }
static void Main(string[] args) { try { //first CustomerContainer ctx = new CustomerContainer(); try { var q = from c in ctx.CUSTOMERS select c; List <CUSTOMER> CustList = q.ToList(); foreach (CUSTOMER item in CustList) { Console.WriteLine(item.FNAME); } } catch (Exception e) { Console.WriteLine(e.Message); } // second ( multi-value) CustomerContainer ctx2 = new CustomerContainer(); try { var result = ctx2.ExecuteStoreQuery <CUSTOMER_MV>("SELECT * FROM UNNEST CUSTOMER ON ORDERS"); List <CUSTOMER_MV> CustList = result.ToList(); foreach (CUSTOMER_MV item in CustList) { Console.WriteLine(item.FNAME); } } catch (Exception e2) { Console.WriteLine(e2.Message); } } catch (Exception e3) { Console.WriteLine(e3.Message); } finally { Console.WriteLine("Enter to exit:"); string line = Console.ReadLine(); } }