public void LinqParse_Take_const_clause()
{
using (ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd))
{
ARSet <NRemedy_Test_Regular_Form> set = new ARSet <NRemedy_Test_Regular_Form>(context);
var q = from s in set.Take(11)
select s;
Assert.IsTrue(q.Provider is ARQueryProvider <NRemedy_Test_Regular_Form>);
TranslateResult tr = q.Translate <NRemedy_Test_Regular_Form>();
Assert.IsTrue(tr.NoQueryableResult.HasTake);
Assert.IsNotNull(tr.NoQueryableResult.Take);
Assert.AreEqual(11, tr.NoQueryableResult.Take);
}
}
public void LinqParse_Take_Skip_Combine_clause()
{
using (ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd))
{
ARSet <NRemedy_Test_Regular_Form> set = new ARSet <NRemedy_Test_Regular_Form>(context);
var q = from s in set.Take(10).Skip(2)
select s;
TranslateResult tr = q.Translate <NRemedy_Test_Regular_Form>();
Assert.IsTrue(tr.NoQueryableResult.HasTake);
Assert.IsTrue(tr.NoQueryableResult.HasSkip);
Assert.AreEqual(10, tr.NoQueryableResult.Take);
Assert.AreEqual(2, tr.NoQueryableResult.Skip);
}
}
public void LinqQuery_Take_Skip_Combine_clause()
{
using (ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd))
{
ARSet <NRemedy_Test_Regular_Form> set = new ARSet <NRemedy_Test_Regular_Form>(context);
var q = from s in set.Take(9).Skip(7)
select s;
int count = 0;
foreach (var g in q)
{
Assert.AreEqual(TestCharacterFieldValueChinese, g.CharacterField);
count++;
}
Assert.AreEqual(9, count);
}
}
public void LinqParse_Take_muti_exception_clause()
{
using (ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd))
{
string i = "10";
ARSet <NRemedy_Test_Regular_Form> set = new ARSet <NRemedy_Test_Regular_Form>(context);
var q = from s in set.Take(Convert.ToInt32(i)).Take(1)
select s;
Assert.IsTrue(q.Provider is ARQueryProvider <NRemedy_Test_Regular_Form>);
try
{
TranslateResult tr = q.Translate <NRemedy_Test_Regular_Form>();
}
catch (Exception ex)
{
Assert.AreEqual(typeof(NotSupportedException), ex.GetType());
}
}
}
public void LinqQuery_Take_Skip_Combine_clause()
{
using (ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd))
{
ARSet<NRemedy_Test_Regular_Form> set = new ARSet<NRemedy_Test_Regular_Form>(context);
var q = from s in set.Take(9).Skip(7)
select s;
int count = 0;
foreach (var g in q)
{
Assert.AreEqual(TestCharacterFieldValueChinese, g.CharacterField);
count++;
}
Assert.AreEqual(9, count);
}
}
public void LinqParse_Take_var_clause()
{
using (ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd))
{
string i = "10";
ARSet<NRemedy_Test_Regular_Form> set = new ARSet<NRemedy_Test_Regular_Form>(context);
var q = from s in set.Take(Convert.ToInt32(i))
select s;
Assert.IsTrue(q.Provider is ARQueryProvider<NRemedy_Test_Regular_Form>);
TranslateResult tr = q.Translate<NRemedy_Test_Regular_Form>();
Assert.IsTrue(tr.NoQueryableResult.HasTake);
Assert.IsNotNull(tr.NoQueryableResult.Take);
Assert.AreEqual(10, tr.NoQueryableResult.Take);
}
}
public void LinqParse_Take_Skip_Combine_clause()
{
using (ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd))
{
ARSet<NRemedy_Test_Regular_Form> set = new ARSet<NRemedy_Test_Regular_Form>(context);
var q = from s in set.Take(10).Skip(2)
select s;
TranslateResult tr = q.Translate<NRemedy_Test_Regular_Form>();
Assert.IsTrue(tr.NoQueryableResult.HasTake);
Assert.IsTrue(tr.NoQueryableResult.HasSkip);
Assert.AreEqual(10, tr.NoQueryableResult.Take);
Assert.AreEqual(2, tr.NoQueryableResult.Skip);
}
}
public void LinqParse_Take_muti_exception_clause()
{
using (ARLoginContext context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd))
{
string i = "10";
ARSet<NRemedy_Test_Regular_Form> set = new ARSet<NRemedy_Test_Regular_Form>(context);
var q = from s in set.Take(Convert.ToInt32(i)).Take(1)
select s;
Assert.IsTrue(q.Provider is ARQueryProvider<NRemedy_Test_Regular_Form>);
try
{
TranslateResult tr = q.Translate<NRemedy_Test_Regular_Form>();
}
catch (Exception ex)
{
Assert.AreEqual(typeof(NotSupportedException), ex.GetType());
}
}
}
