C# (CSharp) DataLayer.DataAccess DataAccessHelper示例

示例#1

 public IEnumerable <CategoryData> GetCategoryData()
 {
     return(DataAccessHelper.FillTable <CategoryData>($"SELECT * FROM {TableName}", _configuration));
 }

示例#2

 public CategoryData GetCategoryData(int categoryId)
 {
     return(DataAccessHelper.GetSingle <CategoryData>($"SELECT * FROM {TableName} WHERE {ColumnNames.PrimaryKey} = {categoryId}", _configuration));
 }

示例#3

文件： LearningDataAccess.cs 项目： Timmeey86/CoreWebApp

 public LearningData GetLearningData(int learningDataId)
 {
     return(DataAccessHelper.GetSingle <LearningData>($"SELECT * FROM {TableName} WHERE {ColumnNames.PrimaryKey} = {learningDataId}", _configuration));
 }