【freesql】使用Ado执行sql语句查询结果集时参数化举例

2023年6月21日发(作者：)

【freesql】使⽤Ado执⾏sql语句查询结果集时参数化举例

StringBuilder sb = new StringBuilder();("select ,nid,nname,ndesc,e,");("s,,,ishtime,ledcapacity,ledpower,de,ude,");("left join enery_storage_station c on nid = nid ");(" where 1=1 ");if (!OrWhiteSpace(name)){Format(" and nname like '%{0}%'",@name);}return _eeSql().(ng(), new SqlParameter { ParameterName = "@name", Value = name });

2023年6月21日发(作者：)

【freesql】使⽤Ado执⾏sql语句查询结果集时参数化举例

StringBuilder sb = new StringBuilder();("select ,nid,nname,ndesc,e,");("s,,,ishtime,ledcapacity,ledpower,de,ude,");("left join enery_storage_station c on nid = nid ");(" where 1=1 ");if (!OrWhiteSpace(name)){Format(" and nname like '%{0}%'",@name);}return _eeSql().(ng(), new SqlParameter { ParameterName = "@name", Value = name });