C# Dapper支持防止SQL注入

            string userId = "';DELETE FROM User WHERE Id=5;'";
            string sql = @"SELECT * FROM User WHERE Id = @userId";
            DynamicParameters parameters = new DynamicParameters();
            parameters.Add("userId", userId);

经过Dapper处理执行的SQL输出,会将 ' 转义字符为 \'

SELECT * FROM User WHERE Id = '\';DELETE FROM User WHERE Id=5;\'';
会替换一些sql关键字
posted @ 2022-01-27 17:34  vba是最好的语言  阅读(419)  评论(0)    收藏  举报