public IEnumerable <DocumentViewModel> FilterFilesByGuid(string currentSid) { _logger.LogDebug($"Return files from database by current sid"); Select select = Qb.Select(nameof(Document.path), nameof(Document.upload_time_stamp), nameof(Document.short_name), nameof(Document.picture), nameof(Document.doc_id)) .From(Tables.Document) .Where( Cond.Equal(nameof(Document.user_sid), currentSid), Cond.Equal(nameof(Document.type), Convert.ToByte(IO.FileExtension.Extensions.Pdf)) ); IEnumerable <DocumentViewModel> documents; try { using (AnyDbConnection connection = _factory.OpenConnection()) { return(documents = connection.Query <DocumentViewModel>(select)); } } catch (Exception ex) { _logger.LogError(ex.Message); } _logger.LogDebug($"FileDbService.FilterFilesByGuid....OK"); return(null); }
public void SelectTest() { Select sel = Qb.Select("*") .From("customer").OrderBy("id"); using (AnyDbConnection con = _factory.OpenConnection()) { var res = con.Query(sel); Assert.Equal(100, res.Count()); } }
public static IEnumerable <T> Query <T>(this AnyDbConnection cnn, Select query, IDbTransaction transaction = null, bool buffered = true, int?commandTimeout = null) { string sql = GetSelectSql(cnn, query); if (!commandTimeout.HasValue) { commandTimeout = cnn.DefaultCommandTimeout; } DynamicParameters parameters = GetParameters(query.Query.CommandParams); return(cnn.Query <T>(sql, parameters, transaction, buffered, commandTimeout, CommandType.Text)); }
public void GetPageSqlTest() { Select sel = Qb.Select("*") .From("customer").OrderBy("id").Page(1, 10); string sql = _factory.GetSql(sel); using (AnyDbConnection con = _factory.OpenConnection()) { var res = con.Query(sel); Assert.Equal(10, res.Count()); } }
public static IEnumerable <TReturn> Query <TFirst, TSecond, TThird, TFourth, TFifth, TSixth, TSeventh, TReturn>(this AnyDbConnection cnn, Select query, Func <TFirst, TSecond, TThird, TFourth, TFifth, TSixth, TSeventh, TReturn> func, IDbTransaction transaction = null, bool buffered = true, int?commandTimeout = null, string splitOn = "Id") { string sql = GetSelectSql(cnn, query); if (!commandTimeout.HasValue) { commandTimeout = cnn.DefaultCommandTimeout; } DynamicParameters parameters = GetParameters(query.Query.CommandParams); return(cnn.Query <TFirst, TSecond, TThird, TFourth, TFifth, TSixth, TSeventh, TReturn>(sql, func, parameters, transaction, buffered, commandTimeout: commandTimeout, splitOn: splitOn)); }
IEnumerable <Customer> GetAll(AnyDbConnection con) { Select sel = Qb.Select("*").From("customer"); return(con.Query <Customer>(sel)); }