本文整理汇总了C#中System.Data.SqlClient.SqlConnection.GetList方法的典型用法代码示例。如果您正苦于以下问题：C# SqlConnection.GetList方法的具体用法？C# SqlConnection.GetList怎么用？C# SqlConnection.GetList使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlClient.SqlConnection的用法示例。
在下文中一共展示了SqlConnection.GetList方法的5个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CheckPersonWithIdGreaterThan2AndLessThan4
public void CheckPersonWithIdGreaterThan2AndLessThan4()
{
List<IPerson> mockPersons = table.GetTable().Where(p => p.Id > 2 && p.Id < 4).ToList();
using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString))
{
conn.Open();
IList<Person> persons = conn.GetList<Person>("Select Id,Name From PERSON Where Id > @from and Id < @to",
new { from = 2, to = 4 });
}
}示例2: GetRules
public ICollection<Rule> GetRules()
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var list = connection.GetList<Rule>();
connection.Close();
return list.ToList();
}
}示例3: GetAllUserModuleByLdapUser
public IList<Model.Entities.UserModule> GetAllUserModuleByLdapUser(Model.Entities.UserModule userModule)
{
IEnumerable<UserModule> result = new List<UserModule>();
using (SqlConnection cn = new SqlConnection(ApplicationConfiguration.ConnectionString))
{
cn.Open();
var predicateGroup = new PredicateGroup { Operator = GroupOperator.And, Predicates = new List<IPredicate>() };
predicateGroup.Predicates.Add(Predicates.Field<UserModule>(f => f.LdapName, Operator.Eq, userModule.LdapName));
result = cn.GetList<UserModule>(predicateGroup);
cn.Close();
}
return result.ToList();
}示例4: CheckPersonWithNameLikeM
public void CheckPersonWithNameLikeM()
{
List<IPerson> mockPersons = table.GetTable().Where(p => p.Name.StartsWith("M")).ToList();
using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString))
{
conn.Open();
var persons = conn.GetList<Person>("Select Id,Name From PERSON Where Name like 'M%'");
Assert.AreEqual(mockPersons.Count, persons.Count);
for (int i = 0; mockPersons.Count > i; i++)
{
Assert.AreEqual(mockPersons[i].Id, persons[i].Id);
Assert.AreEqual(mockPersons[i].Name, persons[i].Name);
}
}
}示例5: NullDOB
public void NullDOB()
{
using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString))
{
conn.Open();
Assert.DoesNotThrow(() =>
{
conn.GetList<Person>("Select NULL as DateOfBirth From PERSON");
});
}
}