|
0
|
1 using System;
|
|
|
2
|
|
|
3 using NUnit.Framework;
|
|
|
4
|
|
|
5 using BLToolkit.Data.DataProvider;
|
|
|
6
|
|
|
7 namespace Data.Linq.ProviderSpecific
|
|
|
8 {
|
|
|
9 [TestFixture]
|
|
|
10 public class Access : TestBase
|
|
|
11 {
|
|
|
12 [Test]
|
|
|
13 public void SqlTest()
|
|
|
14 {
|
|
|
15 using (var db = new TestDbManager(ProviderName.Access))
|
|
|
16 {
|
|
|
17 var res = db
|
|
|
18 .SetCommand(@"
|
|
|
19 UPDATE
|
|
|
20 [Child] [c]
|
|
|
21 LEFT JOIN [Parent] [t1] ON [c].[ParentID] = [t1].[ParentID]
|
|
|
22 SET
|
|
|
23 [ChildID] = @id
|
|
|
24 WHERE
|
|
|
25 [c].[ChildID] = @id1 AND [t1].[Value1] = 1
|
|
|
26 ",
|
|
|
27 db.Parameter("@id1", 1001),
|
|
|
28 db.Parameter("@id", 1002))
|
|
|
29 .ExecuteNonQuery();
|
|
|
30 }
|
|
|
31 }
|
|
|
32 }
|
|
|
33 }
|
