Linq query example that returns a single result
LinqCEFPDataContext ctx = new LinqCEFPDataContext(); vw_RepairLog rl = ctx.vw_RepairLogs.Where(c => c.RepairLogID == intRepairLogID).Single();