Mercurial > pub > bltoolkit
view UnitTests/Linq/ProviderSpecific/Access.cs @ 9:1e85f66cf767 default tip
update bltoolkit
author | nickolay |
---|---|
date | Thu, 05 Apr 2018 20:53:26 +0300 |
parents | f990fcb411a9 |
children |
line wrap: on
line source
using System; using NUnit.Framework; using BLToolkit.Data.DataProvider; namespace Data.Linq.ProviderSpecific { [TestFixture] public class Access : TestBase { [Test] public void SqlTest() { using (var db = new TestDbManager(ProviderName.Access)) { var res = db .SetCommand(@" UPDATE [Child] [c] LEFT JOIN [Parent] [t1] ON [c].[ParentID] = [t1].[ParentID] SET [ChildID] = @id WHERE [c].[ChildID] = @id1 AND [t1].[Value1] = 1 ", db.Parameter("@id1", 1001), db.Parameter("@id", 1002)) .ExecuteNonQuery(); } } } }