本文整理汇总了C#中DataContext.Translate方法的典型用法代码示例。如果您正苦于以下问题：C# DataContext.Translate方法的具体用法？C# DataContext.Translate怎么用？C# DataContext.Translate使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataContext的用法示例。
在下文中一共展示了DataContext.Translate方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetEvents
/// <summary>
/// Return IEnumerable of SQL Server query results
/// </summary>
/// <returns></returns>
private static IEnumerable<ServerEvent> GetEvents()
{
//define connection string
string connString = "Data Source=.;Initial Catalog=DemoDb;Integrated Security=SSPI;";
//create enumerable to hold results
IEnumerable<ServerEvent> result;
//define dataconext object which is used later for translating results to objects
DataContext dc = new DataContext(connString);
//initiate and open connection
conn = (SqlConnection)dc.Connection;
conn.Open();
//return all events stored in the SQL Server table
SqlCommand command = new SqlCommand("select ID, ServerName, Level, Timestamp From ServerEvent", conn);
//get the database results and set the connection to close after results are read
SqlDataReader dataReader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
//use "translate" to flip the reader stream to an Enumerable of my custom object type
result = dc.Translate<ServerEvent>(dataReader);
return result;
}示例2: CreateSqlEnumerable
private static void CreateSqlEnumerable()
{
string connString = "Data Source=.;Initial Catalog=DemoDb;Integrated Security=SSPI;";
using (DataContext dc = new DataContext(connString))
{
SqlConnection conn = (SqlConnection)dc.Connection;
conn.Open();
SqlCommand command = new SqlCommand("select ID, ServerName, Level, Timestamp From ServerEvent", conn);
SqlDataReader dataReader = command.ExecuteReader();
var result = dc.Translate<ServerEvent>(dataReader);
foreach (ServerEvent evt in result)
{
Console.WriteLine("***************");
Console.WriteLine(evt.Id);
Console.WriteLine(evt.ServerName);
Console.WriteLine(evt.Level);
}
}
Console.ReadLine();
}