Mercurial > pub > bltoolkit

comparison UnitTests/Linq/ProviderSpecific/MsSql2008s.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 using System.Linq;
3 using BLToolkit.Data.Linq;
4 using NUnit.Framework;
5
6 namespace Data.Linq.ProviderSpecific
7 {
8 [TestFixture]
9 public class MsSql2008 : TestBase
10 {
11 [Test]
12 public void SqlTest([IncludeDataContexts("Sql2008", "Sql2012")] string context)
13 {
14 using (var db = new TestDbManager(context))
15 using (var rd = db.SetCommand(@"
16 SELECT
17 DateAdd(Hour, 1, [t].[DateTimeValue]) - [t].[DateTimeValue]
18 FROM
19 [LinqDataTypes] [t]")
20 .ExecuteReader())
21 {
22 if (rd.Read())
23 {
24 var value = rd.GetValue(0);
25 }
26 }
27 }
28
29 [Test]
30 public void SqlTypeTest([IncludeDataContexts("Sql2008", "Sql2012")] string context)
31 {
32 using (var db = new TestDbManager(context))
33 {
34 var q =
35 from p in db.Parent
36 join c in db.Child on p.ParentID equals c.ParentID into g
37 from c in g.DefaultIfEmpty()
38 select new {p, b = Sql.AsSql((int?)c.ParentID) };
39
40 var list = q.ToList();
41
42
43 var value = db.SetCommand(@"SELECT SmallIntValue FROM LinqDataTypes WHERE ID = 1").ExecuteScalar<short>();
44
45 db.SetCommand(@"UPDATE LinqDataTypes SET SmallIntValue = @value WHERE ID = 1", db.Parameter("value", (ushort)value)).ExecuteNonQuery();
46 }
47 }
48 }
49 }