[转]Lost parameter value during SQL trace in EF Core DbParameter 为 问号 ?
本文转自:https://stackoverflow.com/questions/44202478/lost-parameter-value-during-sql-trace-in-ef-core
问:
I have implemented an approach for tracing SQL queries from EF Core according to this article: https://docs.microsoft.com/en-us/ef/core/miscellaneous/logging.
And have problems with tracing query parameteres.
When I recive Log event in all values of DbParameterLogData
I see only the question mark instead of the actual values wich I passed to the query. Example image VS 2015. Thank you!
答:
This is the default behavior of EF Core (filling up the DbParameterLogData.Value
property with "?"
).
In order to get the real parameter values, you need to enable sensitive data logging by using DbContextOptionsBuilder.EnableSensitiveDataLogging
method:
Enables application data to be included in exception messages, logging, etc. This can include the values assigned to properties of your entity instances, parameter values for commands being sent to the database, and other such data. You should only enable this flag if you have the appropriate security measures in place based on the sensitivity of this data.
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.EnableSensitiveDataLogging();
// ...
}
Sometimes this results in a MissingMethodException.
In which case, you should call it in ConfigureServices():
services.AddDbContext<MyDbContext>(options => options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")).EnableSensitiveDataLogging()) – yfisaqt Jul 6 at 21:10
最新文章
- 阿里yum源
- ASN.1编码
- [git]git开发流程
- codeforces #round363 div2.C-Vacations (DP)
- win7+cygwin+hadoop+eclipse
- HTMLParser-简单HTML和XHTML解析
- python返回null和空的不同
- [leetcode-598-Range Addition II]
- L2-013 红色警报 (25 分)
- 用keras实现基本的回归问题
- 学生信息管理系统(C语言)
- linux下使用命令修改IP地址
- python3 第二十四章 - 函数式编程之Anonymous function(匿名函数)
- 基于pycaffe的网络训练和结果分析(mnist数据集)
- this和引用变量的地址值是同一个---------new后面的是构造方法
- 廖雪峰Java1-4数组操作-4多维数组
- [网络]10M、100M、1000M网线的水晶头接法
- Python学习--和 Oracle 交互
- 一个IOS自动化打包的脚本
- P2617 Dynamic Rankings