本文整理汇总了C#中System.Data.SqlClient.SqlConnection.ExecuteSingleValue方法的典型用法代码示例。如果您正苦于以下问题：C# SqlConnection.ExecuteSingleValue方法的具体用法？C# SqlConnection.ExecuteSingleValue怎么用？C# SqlConnection.ExecuteSingleValue使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlClient.SqlConnection的用法示例。
在下文中一共展示了SqlConnection.ExecuteSingleValue方法的5个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ReadAll
public void ReadAll()
{
var db = ConnectTo.Sql2005(Config.TestDBConnectionString);
var results = db.ReadAll<Person>();
int actualCount = int.MinValue;
using (var conn = new SqlConnection(Config.TestDBConnectionString))
{
actualCount = conn.ExecuteSingleValue<int>("select count(*) from Person");
}
Assert.AreEqual(results.Count(), actualCount);
}示例2: ReadAllCustomFields
public void ReadAllCustomFields()
{
var db = ConnectTo.Sql2005(Config.TestDBConnectionString);
db.Insert("Person", new Person { FirstName = "Foo" });
var desiredColumns = new List<string>(){ "PersonId", "FirstName" };
var results = db.ReadAll("Person", desiredColumns);
int actualCount = int.MinValue;
using (var conn = new SqlConnection(Config.TestDBConnectionString))
{
actualCount = conn.ExecuteSingleValue<int>("select count(*) from Person");
}
//Make sure we get all of the rows in the table
Assert.AreEqual(results.Count(), actualCount);
//Make sure we only got the columns we requested rather than entire rows
Assert.AreEqual(results.First().Keys.ToList(), desiredColumns);
}示例3: ReadAllCustomFields
public void ReadAllCustomFields()
{
var db = new RealDB(connString, new SQL2005DBAnalyzer(connString));
var desiredColumns = new List<string>(){ "PersonId", "FirstName" };
var results = db.RawReadAllCustomFields("Person", desiredColumns);
int actualCount = int.MinValue;
using (var conn = new SqlConnection(connString))
{
actualCount = conn.ExecuteSingleValue<int>("select count(*) from Person");
}
//Make sure we get all of the rows in the table
Assert.AreEqual(results.Count(), actualCount);
//Make sure we only got the columns we requested rather than entire rows
Assert.AreEqual(results.First().Keys.ToList(), desiredColumns);
}示例4: sqlInsert
private int? sqlInsert(string sql, ITransaction transaction, Dictionary<string, object> values = null)
{
if (values == null)
values = new Dictionary<string, object>();
//If no transaction is passed in we will make our own connection
if (transaction == null)
{
using (var conn = new SqlConnection(connectionString))
{
return conn.ExecuteSingleValue<int?>(sql, values);
}
}
//If a transaction is passed in we will use the global connection
else
{
var command = new SqlCommand(sql, _conn, (transaction as RealDBTransaction).UnderlyingTransaction);
return command.ExecuteSingleValue<int?>(sql, values);
}
}示例5: ReadAll
public void ReadAll()
{
var db = new RealDB(connString, new SQL2005DBAnalyzer(connString));
var results = db.ReadAll<Person>();
int actualCount = int.MinValue;
using (var conn = new SqlConnection(connString))
{
actualCount = conn.ExecuteSingleValue<int>("select count(*) from Person");
}
Assert.AreEqual(results.Count(), actualCount);
}