本文整理汇总了C#中System.Data.SQLite.SQLiteDataReader.Fetch方法的典型用法代码示例。如果您正苦于以下问题:C# SQLiteDataReader.Fetch方法的具体用法?C# SQLiteDataReader.Fetch怎么用?C# SQLiteDataReader.Fetch使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SQLite.SQLiteDataReader
的用法示例。
在下文中一共展示了SQLiteDataReader.Fetch方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ReadSelectListItem
private SelectListItem ReadSelectListItem(SQLiteDataReader reader)
{
return new SelectListItem
{
Value = reader.Fetch<long>("ID").ToString(),
Text = reader.Fetch<string>("Name")
};
}
示例2: ReadCategory
private Category ReadCategory(SQLiteDataReader reader)
{
return new Category
{
ID = reader.Fetch<long>("ID"),
Name = reader.Fetch<string>("Name"),
CreatedOn = reader.Fetch<DateTime>("CreatedOn")
};
}
示例3: ReadUser
private User ReadUser(SQLiteDataReader reader)
{
User user = new User
{
Name = reader.Fetch<string>("Name"),
CreatedOn = reader.Fetch<DateTime>("CreatedOn")
};
return user;
}
示例4: ReadComment
private Comment ReadComment(SQLiteDataReader reader)
{
return new Comment
{
Body = reader.Fetch<string>("Body"),
CreatedBy = reader.Fetch<long>("CreatedBy"),
CreatedOn = reader.Fetch<DateTime>("CreatedOn"),
ID = reader.Fetch<long>("ID"),
ModifiedBy = reader.Fetch<long>("ModifiedBy"),
ModifiedOn = reader.Fetch<DateTime>("ModifiedOn"),
Title = reader.Fetch<string>("Title")
};
}
示例5: ReadPostSummary
private PostSummary ReadPostSummary(SQLiteDataReader reader)
{
PostSummary postSummary = new PostSummary
{
CategoryName = reader.Fetch<string>("CategoryName"),
DateDetails = reader.Fetch<DateTime>("CreatedOn").ToDisplayDate(),
PostID = reader.Fetch<long>("PostID"),
Subject = reader.Fetch<string>("Subject"),
Summary = reader.Fetch<string>("Summary"),
UserID = reader.Fetch<long>("UserID"),
UserName = reader.Fetch<string>("UserName")
};
if (postSummary.Summary.Length == Constants.PostSummaryLength - 1)
{
postSummary.Summary += "…";
}
return postSummary;
}
示例6: ReadPost
private Post ReadPost(SQLiteDataReader reader)
{
return new Post
{
Body = reader.Fetch<string>("Body"),
CategoryID = reader.Fetch<long>("CategoryID"),
CreatedBy = reader.Fetch<long>("CreatedBy"),
CreatedOn = reader.Fetch<DateTime>("CreatedOn"),
ID = reader.Fetch<long>("ID"),
ModifiedBy = reader.Fetch<long>("ModifiedBy"),
ModifiedOn = reader.Fetch<DateTime>("ModifiedOn"),
Subject = reader.Fetch<string>("Subject")
};
}