Dapper
Dapper copied to clipboard
DapperLib
Dapper - a simple object mapper for .Net
I have a SQLite database with a table that has a column defined as the following: `CreatedDate DateTime DEFAULT (date('now')),` While using Dapper Execute command, I can insert a new...
QuerySingleOrDefault with SQLite in gives the error “'Must add values for the following parameters”
I am trying to execute the following Dapper query against a SQLite 3 database: ``` conn.QuerySingleOrDefault ("select id, modelId, tableName, schemaName from tables where tableName = $tableName;", new {tableName}); ```...
I'm not sure whether or not I'm doing something wrong with the library, however: I have a custom type handler for one of my classess. When I use this type...
Hi, I'm working with Dapper and Oracle database and using `Guid` data type on some of my columns. Due to that fact I had to create custom `TypeHandler` in order...
Here's a full description of the problem: https://stackoverflow.com/questions/28678442/how-can-i-make-dapper-net-throw-when-result-set-has-unmapped-columns The solution seems really hacky. This would be a great feature to have to proactively surface bugs in queries.
Hi, I have a branch here https://github.com/osexpert/Dapper/tree/TVPParameters I have added support for TVP directly as argument. Example: ``` SqlMapper.Settings.InListTVPCount = 1; var list = new List(); list.Add(42); // Add some...
I face same issue in .net 4.8 and .net 5,6 and 7 also, whenever I use queryasync, queryfirstordefaultasync() ... Any async functions with or without await is not working. it...
The method `public static Task QueryAsync(this IDbConnection cnn, string sql, Func map, object param = null, IDbTransaction transaction = null, bool buffered = true, string splitOn = "Id", int? commandTimeout...
I'm trying to resolve a problem with a class that contains a `List` property. In this case, when I use a QueryFirstOrDefault, Dapper does not fill the property correctly, throwing...
``` csharp using (var conn = new SqlConnection(appToken.ConnectionString)) { conn.Open(); var ret = conn.Query("select a='dog',b=3", (string a, int b) => a + b, splitOn: "b", buffered: false); Console.WriteLine(string.Join("", ret)); ret...
