EF在處理并發上并不是很好，很多時候我們需要手動寫sql操作資料庫，但是在基類中我們如何獲取當前服務倉儲操作的表呢？
使用正則是其中一種解決辦法
Repository.Table是一條查詢陳述句，通過toString獲取sql陳述句再用正則提取表名var sql= Repository.Table.ToString();var regex = new Regex("FROM (?<table>.*) AS");var match = regex.Match(sql);string table = match.Groups["table"].Value;
其中sql=
SELECT "Extent1"."uuid", "Extent1"."imageid", "Extent1"."description", "Extent1"."order", "Extent1"."tags", "Extent1"."isdefault", "Extent1"."billid", "Extent1"."filename",
"Extent1"."fileext", "Extent1"."filesize", "Extent1"."storepath", "Extent1"."storename", "Extent1"."createby", "Extent1"."createon", "Extent1"."updateby", "Extent1"."updateon"
FROM "dbo"."plm_commissionerinfoimage" AS "Extent1"
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/1658.html