jin li Zhang

Results 5 comments of jin li Zhang

i have already add a guid handler ` public class RawGuidHandler : SqlMapper.TypeHandler { public override Guid Parse(object value) { if (value is byte[] byteArray) { return new Guid(byteArray); }...

in fact , i have removed brackets。 and the stacktrace is ![无标题](https://user-images.githubusercontent.com/84027353/206462121-acb67e52-dc15-42f9-bc1a-764b7f7bf98c.png)

in my db data models , Id is RAW(16), it should use RawGuidHandler.

if the sql likes "select * from table where id = :Id", and Id = { Guid }. dapper can execute correctly . can you tell me what does dapper...

alright. i did a temp solution, it's bellow ` var sqlBuilder = new StringBuilder() .Append(" with src as (") .Append(" SELECT DISTINCT r.\"UserId\", f.\"UserName\", f.\"UserNo\", d.\"DeptName\", SUM(r.\"Points\") over (partition by...