Dapper
Dapper copied to clipboard
DapperLib
Dapper - a simple object mapper for .Net
It's a very simple query with a `LIKE` operator on an access database: ``` csharp string sql = "SELECT FROM Users WHERE UserName LIKE ?"; var result = conn.Query(sql, "%ab%"});...
I have a database that has a date property. However, the C# class is DateOnly since I only need the date, not the time. However, when I try to use...
I have exactly the same problem as it is described here: http://stackoverflow.com/questions/28727962/dapper-custom-typehandler-setvalue-not-being-called Update: There is a second thread with the same problem: http://stackoverflow.com/questions/25568657/dapper-typehandler-setvalue-not-being-called?rq=1
We have developed an API project in .Net Core 2.2 and Dapper 2.0.30 with Microsoft SQL Server 2017 database. Sometimes it happens after a new build in release, that we...
I have some custom classes that hides some logic but is basically only a simple .Net Type. Think Email, there you can create a EMail class, that validates the string...
I have a created date column with type of Timestamp with Time Zone in oracle. My C# model property type is a DateTimeOffset. It sets the value, but it loses...
Consider this application: ```csharp class Program { static async Task Main(string[] args) { const string connectionString = "User ID=postgres;Password=postgres;Host=localhost;Port=5432;Database=ac;"; await using var connection = new NpgsqlConnection(connectionString); DateTime? param = null;...
hello there, here we have an entity like this: ``` public enum ContentType { TXT, MD, HTML } [Table("card")] public class Card: BaseEntityUInt64 { [Column("uid")] public ulong UID { get;...
I found when calling a stored procedure that has a DbString property and that instance is null, a NullReference exception is thrown. ```lua Unhandled exception. System.NullReferenceException: Object reference not set...
My Id is defined in tSQL as ``` id NVARCHAR (128) DEFAULT (NEWID()) NOT NULL ``` and in C# as ``` public Guid Id { get; set; } ``` Dapper...
