linq - 使用 Linq 插入新记录时如何获取 SQL 命令文本？

Question

var newUser = new tblUser() { 
    Email = strEmail,
    Password = strPassword,
    DateBirth = DateTime.Parse(strDateBirth),
};
db.tblUsers.InsertOnSubmit(newUser);
db.SubmitChanges();

我想获取 linq 生成的实际 SQL 查询。

Answer 1

您需要将 DataContext.Log 属性设置为编写器，您可以将编写器包装在字符串生成器周围，然后在插入响应后写入您的 stringbuilder.tostring...

                        StringBuilder sb = new StringBuilder();
                StringWriter writer = new StringWriter(sb);
                Context.Log = writer;
                ...
                    DOINSERT & SUBMITCHANGES
                ...
                Response.Write(sb.ToString());