本文整理汇总了C#中System.Data.SqlHelper.ExecuteDataReader方法的典型用法代码示例。如果您正苦于以下问题:C# SqlHelper.ExecuteDataReader方法的具体用法?C# SqlHelper.ExecuteDataReader怎么用?C# SqlHelper.ExecuteDataReader使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlHelper
的用法示例。
在下文中一共展示了SqlHelper.ExecuteDataReader方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetPurchaseOrderItems
/// <summary>
/// Gets a collection PurchaseOrderItem objects by custom where clause and order by.
/// </summary>
/// <param name="prefix">The prefix clause allows you to inject a distinct or top clause.</param>
/// <param name="where">The where clause to use for the query. Should be parameterized and start with "where"</param>
/// <param name="parameters">The parameters that are listed in the where clause</param>
/// <param name="orderBy">the order by clause. Shoudl start with "order by"</param>
/// <returns>The retrieved collection of PurchaseOrderItem objects.</returns>
protected static EntityList<PurchaseOrderItem> GetPurchaseOrderItems(string prefix, string where, System.Collections.Generic.List<SqlParameter> parameters, string orderBy)
{
string commandText = @"SELECT " + prefix + "" + PurchaseOrderItem.SelectFieldList + "FROM [dbo].[PurchaseOrderItems] " + where + " " + orderBy;
using (SqlHelper helper = new SqlHelper())
{
using (IDataReader reader = helper.ExecuteDataReader(commandText, CommandType.Text, parameters))
{
return EntityBase.InitializeList<PurchaseOrderItem>(reader);
}
}
}
示例2: GetColumnInfoLookup
/// <summary>
/// Get Column Info
/// </summary>
/// <param name="entityType"></param>
/// <returns></returns>
public static Dictionary<string, ColumnInfo> GetColumnInfoLookup(System.Type entityType)
{
if (_columnInfo == null)
{
_columnInfo = new Dictionary<Type, Dictionary<string, ColumnInfo>>();
}
if (!_columnInfo.ContainsKey(entityType))
{
_columnInfo[entityType] = new Dictionary<string,ColumnInfo>();
_columnInfoDefaultValueKeys[entityType] = new List<string>();
System.Reflection.PropertyInfo property = entityType.GetProperty("TableName", BindingFlags.Public | BindingFlags.Static);
if (property != null)
{
string tableName = property.GetValue(null, null) as string;
string commandText = @"select c.COLUMN_NAME, c.COLUMN_DEFAULT, c.DATA_TYPE, c.IS_NULLABLE, c.CHARACTER_MAXIMUM_LENGTH, ep.value as FriendlyName from INFORMATION_SCHEMA.COLUMNS c
inner join sys.columns sc ON OBJECT_ID(c.TABLE_SCHEMA + '.' + c.TABLE_NAME) = sc.[object_id] AND c.COLUMN_NAME = sc.name
LEFT OUTER JOIN sys.extended_properties ep ON sc.[object_id] = ep.major_id AND sc.[column_id] = ep.minor_id AND ep.class = 1 and ep.Name = 'NSFx_FriendlyName'
WHERE c.TABLE_NAME = @TableName";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@TableName", tableName));
try
{
using (SqlHelper helper = new SqlHelper())
{
System.Data.IDataReader reader = helper.ExecuteDataReader(commandText, CommandType.Text, parameters);
while (reader.Read())
{
ColumnInfo columnInfo = new ColumnInfo(reader);
_columnInfo[entityType].Add(columnInfo.ColumnName, columnInfo);
if (columnInfo.Value != null)
{
try
{
_columnInfoDefaultValueKeys[entityType].Add(columnInfo.ColumnName);
}
catch { }
}
}
}
}
catch { }
}
}
return _columnInfo[entityType];
}