public static async Task Load_UnusedData() { List <UnusedData> data = null; using (var context = new Example2Context()) { data = await context.UnusedData .Where(x => TestID.Test_IDS.Contains(x.CorelogicDataID)) .ToListAsync(); } foreach (var d in data) { Console.WriteLine($"ID = {d.CorelogicDataID}, F-Name = {d.Property_Address_Full}"); } Console.WriteLine($"Total count = {data.Count()}"); }
public static async Task Load_UnusedDataOrder() { var orderId = 87746; List <UnusedDataOrder> data = null; using (var context = new Example2Context()) { data = await context.UnusedDataOrder .Where(x => x.OrderId == orderId) .Where(x => TestID.Test_IDS.Contains(x.CorelogicDataId)) .ToListAsync(); } foreach (var d in data) { Console.WriteLine($"ID = {d.CorelogicDataId}, Name = {d.ProgramTypeId}"); } Console.WriteLine($"Total count = {data.Count()}"); }
public static async Task Load_DataProgramtype() { List <DataProgramtype> data = null; using (var context = new Example2Context()) { var query = context.DataProgramtype .Where(x => TestID.Test_IDS.Contains(x.CorelogicDataID)) .Where(x => x.ProgramTypeID == 6); // Console.WriteLine(query.ToQueryString()); data = await query.ToListAsync(); } foreach (var d in data) { Console.WriteLine($"ID = {d.CorelogicDataID}, F-Name = {d.ProgramTypeID}"); } Console.WriteLine($"Total count = {data.Count()}"); }