在SQL Server 2014中写入基础表后立即查询视图

我有一个问题,如果我写一个表(使用 Linq-to-sql),它是视图的依赖,然后马上转过来查询该视图来检查写入的影响(使用新的连接DB,因此是新的数据上下文),写入的影响不会立即显示,但最多需要几秒钟才能显示.这只会偶尔发生(每10万次写入可能是10-20次).

这是视图的定义：

create view [Position].[transactions]
WITH scheR_215_11845@ABINDING
AS
(
  SELECT
    Account,Book,Timeapiclient AS datetiR_215_11845@eUtc,BaseCcy AS Currency,ISNULL(QuantityBase,0) AS Quantity,ValueDate AS SettleDate,ISNULL(CAST(0 AS Tinyint),0) AS transactiontype
  FROM Trades.FxSpotMF
  WHERE IsCancelled = 0

  union all

  SELECT
    Account,QuoteCcy AS Currency,ISNULL(-QuantityBase * Rate,ExecutionTimeUtc AS datetiR_215_11845@eUtc,ISNULL(CAST(1 AS Tinyint),1) AS transactiontype
  FROM Trades.FxSpotManual
  WHERE IsCancelled = 0

  union all

  SELECT
    Account,ISNULL(SpotQuantityBase,SpotValueDate AS SettleDate,ISNULL(CAST(2 AS Tinyint),2) AS transactiontype
  FROM Trades.FxSwap

  union all

  SELECT
    Account,ISNULL(-SpotQuantityBase * SpotRate,ISNULL(ForWARDQuantityBase,ForWARDValueDate AS SettleDate,ISNULL(-ForWARDQuantityBase * ForWARDrate,c.book,TimeUtc AS datetiR_215_11845@eUtc,Currency,ISNULL(amount,SettleDate,ISNULL(CAST(3 AS Tinyint),3) AS transactiontype
  FROM Trades.Commission c
  JOIN Trades.Payment p
    ON c.UniquePaymentId = p.UniquePaymentId
    AND c.book = p.book
)

而这是Linq-to-sql生成的用于写入其中一个基础表的查询：

INSERT INTO [Trades].[FxSpotMF] ([UniqueTradEID],[BaseCcy],[QuoteCcy],[ValueDate],[Rate],[QuantityBase],[Account],[Book],[CounterpartyId],[Counterparty],[ExTradEID],[Timeapiclient],[TimeAPIServer],[TimeExchange],[TimeHandler],[UniqueOrderId],[IsCancelled],[ClientId],[SequencEID],[ExOrdId],[TradeDate],[OrderCyclEID],[CycleIndex])
  VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@P6,@P7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22)

这是Linq-to-sql产生的查询查询效果的查询：

SELECT
  SUM([t0].[Quantity]) AS [Item2],[t0].[Currency] AS [Item1]
FROM [Position].[transactions] AS [t0]
WHERE ([t0].[Book] = @p0)
AND ([t0].[datetiR_215_11845@eUtc] < @p1)
GROUP BY [t0].[Currency]

此外,这是生成写入(使用F#类型提供程序)的Linq-to-sql代码：

type scheR_215_11845@a = Microsoft.fsharp.data.typeproviders.DbmlFile<"TradeDb.dbml",ContextTypename="TradeDb"> 

use db = new scheR_215_11845@a.TradeDb(connectionString)
let Trade = new scheR_215_11845@a.Trades_FxSpotMF()
(* omitted: set object properties corresponding to column values here... *)
db.Trades_FxSpotMF.InsertOnSubmit(TradE)
db.SubmitChanges()

而这是生成读取的相应Linq-to-sql：

use db = new scheR_215_11845@a.TradeDb(connectionString)
query { for t in db.Position_transactions do
        where ( t.book = book &&
                t.datetiR_215_11845@eUtc < df.MaxExecutionTimeExcl
              )
        groupBy t.Currency into group
        let @R_849_10586@l = query { for x in group do sumBy x.Quantity }
        SELEct (group.Key,@R_849_10586@l)
      }
|> Map.ofSeq

我会以为System.Data.Linq.DataContext.SubmitChanges()只会在写入事务完成后返回,并且视图的任何后续查询都必须包含写入的效果…我缺少/做错了什么？