public void should_get_one_result( [Values(FirstBatch, "")] string firstBatch) { var result = SqlStatement.ExecuteSingle <Entity>($"{firstBatch}SELECT TOP 1 * FROM {Database.FirstTable.Name} WHERE Id=@Id", new { Id = 5 }); result.ShouldNotBeNull(); result.Name.Length.ShouldBeGreaterThan(3); result.Id.ShouldEqual(5); result.Values.Count.ShouldEqual(2); ((bool)result.Values["hide"]).ShouldEqual(false); ((DateTime)result.Values["timestamp"]).ShouldBeGreaterThan(DateTime.MinValue); }
public static TEntity ExecuteSingle <TEntity>(this ISqlStatement sqlStatement, string commandText, object parameters) where TEntity : class { return(sqlStatement.ExecuteSingle <TEntity>(commandText, parameters.AsDictionary())); }