var value = reader[0];if( !(value is System.DBNull) ) user.Name = (string)value; value = reader[1];if( !(value is System.DBNull) ) user.Age = (int)value;returnuser; } 最后得出以下Exprssion版本代码 publicstaticclassDemoE
stringsql ="INSERT INTO author (NickName,RealName) VALUES(@nickName,@RealName)";varcolin =newAuthor("Colin","Colin Chang");varrobin =newAuthor("Robin","Robin Song");using(varcnn = Cnn) {awaitcnn.ExecuteAsync(sql,newAuthor[] { colin, robin }); } 1 2 3 4 5 6 7 2) 更新数据 st...
string insertQuery = "INSERT INTO Products (Name, Price) VALUES (@Name, @Price)"; int rowsAffected = dbConnection.Execute(insertQuery, products); Console.WriteLine($"{rowsAffected} rows inserted."); } } 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18....
Execute a query and map it to a list of typed objectspublic class Dog { public int? Age { get; set; } public Guid Id { get; set; } public string Name { get; set; } public float? Weight { get; set; } public int IgnoredProperty { get { return 1; } } } var guid = Guid....
Output);p.Add("c",dbType:DbType.Int32,direction:ParameterDirection.ReturnValue);connection.Execute(...
commandType = null, bool beginTransaction = false) where T : class { return await ExecuteAsync(async (conn, dbTransaction) => { return await conn.QueryFirstOrDefaultAsync<T>(cmd, param, dbTransaction, commandType: commandType ?? CommandType.Text, commandTimeout: commandTimeout); }, beginTrans...
.ForEach(value=>{if(value.ExecuteType !="OpenAsync")all_sql.Add(value.CommandString);if(value.Errored)err_sql.Add(value.CommandString);varlog =$@"【{customTiming.Key}{i++}】{value.CommandString}Execute time :{value.DurationMilliseconds}ms,Start offset :{value.StartMilliseconds}ms,Errored ...
.ForEach(value => { if (value.ExecuteType != "OpenAsync") all_sql.Add(value.CommandString); if (value.Errored) err_sql.Add(value.CommandString); var log = $@"【{customTiming.Key}{i++}】{value.CommandString} Execute time :{value.DurationMilliseconds} ms,Start offset :{value.Start...
{ string sql = "update " + criteria.TableName + " set " + criteria.Fields + " where 1=1 " + criteria.Condition; var result = connection.Execute(sql, Parameters); return result; } /// /// 更新实体 /// /// <typeparam name="T">实体类型</typeparam> /// 实体对象,主键不能缺...
Add("d1","value"); dynamicParameters.Add("a2","value"); dynamicParameters.Add("b2","value"); dynamicParameters.Add("c2","value"); dynamicParameters.Add("d2","value"); result=connection.ExecuteScalar(sql,dynamicParameters); } } catch { } returnresult; } 其余写法大家可以参考上面的写法...