string name = "变量";
string strSql = string.Format("select Id as UserId,RealName as UserName from BY_User where RealName like @RealName");
Database db = DatabaseFactory.CreateDatabase();DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
单引号系统会自己加,但是百分号不会,你如果直接在参数前面 like %@RealName % 会报错,只能在下面加。