如何在 ServiceStack.OrmLite 中执行带参数的 SQL 语句? [英] How do I execute a SQL statement with parameters in ServiceStack.OrmLite?

问题描述

我想在ServiceStack ormlite中执行带参数的SQL语句

I want to execute SQL statement with paraemeters in ServiceStack ormlite

String.Format("SELECT OBJECT_ID(@name)", name);

我想要最好的方式.

推荐答案

如果需要 POCO 结果可以使用:

If you need the POCO result you can use:

List<Person> results = db.SqlList<Person>("SELECT * FROM Person WHERE Age < @age", new { age=50});

参考:https://github.com/ServiceStack/ServiceStack.OrmLite#typed-sqlexpressions-with-custom-sql-apis

这篇关于如何在 ServiceStack.OrmLite 中执行带参数的 SQL 语句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！