//---------------------------------------------------------------------------------------------------------------- public static IEnumerable <AD_GPO_Users> PrintUsersToConsole() { List <AD_GPO_Users> item = db.Query <AD_GPO_Users>("SELECT TOP 10 * FROM AD_GPO_Users").ToList(); foreach (AD_GPO_Users breach in item) { Console.WriteLine(breach); } return(item); }
//---------------------------------------------------------------------------------------------------------------- public static IEnumerable <Breach> PrintBreachesToConsole() { List <Breach> item = db.Query <Breach>("select * from Breach").ToList(); foreach (Breach breach in item) { Console.WriteLine(breach); } return(item); }
//---------------------------------------------------------------------------------------------------------------- public static IEnumerable <Breached_Emails> PrintBreachedEmailsToConsole() { List <Breached_Emails> item = db.Query <Breached_Emails>("SELECT * FROM Breached_Emails").ToList(); foreach (Breached_Emails breach in item) { Console.WriteLine(breach); } return(item); }
public IEnumerable <CurrencyExchangeRateDto> CurrencyExchangeRateList(DateTime date) { IEnumerable <CurrencyExchangeRateDto> result; using (NPoco.IDatabase dbContext = new NPoco.Database(DTO.Global.SQLConnectionString, NPoco.DatabaseType.SqlServer2012)) { result = dbContext.Query <DTO.Database.CurrencyExchangeRateDto>("SELECT * FROM tbl_CurrencyExchangeRate WHERE CurrencyExchangeRateShortDate = " + Helper.DateHelper.ShortDate(date)); } return(result); }