Mercurial > pub > bltoolkit

comparison UnitTests/Linq/ProviderSpecific/Access.cs @ 0:f990fcb411a9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:f990fcb411a9
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 }