public List <SelectListItem> GetMediaDate()
{
List <SelectListItem> mediaDateList = new List <SelectListItem>();
List <MediaDate> mdList = new List <MediaDate>();
var context = new CMSContext();
using (var cnn = context.Database.GetDbConnection())
{
var cmm = cnn.CreateCommand();
cmm.CommandType = System.Data.CommandType.StoredProcedure;
cmm.CommandText = "[dbo].[sp_GetMediaDate]";
cmm.Connection = cnn;
cnn.Open();
var reader = cmm.ExecuteReader();
while (reader.Read())
{
MediaDate mediaDate = new MediaDate();
mediaDate.DateText = Convert.ToString(reader["DateText"]);
mediaDate.DateValue = Convert.ToString(reader["DateValue"]);
mdList.Add(mediaDate);
}
}
mediaDateList = mdList.Select(x => new SelectListItem {
Text = x.DateText, Value = x.DateValue
}).ToList();
return(mediaDateList);
}
public List <SelectListItem> GetMediaDate()
{
List <SelectListItem> mediaDateList = new List <SelectListItem>();
List <MediaDate> mdList = new List <MediaDate>();
var context = new CMSContext();
/*Does not work https://docs.microsoft.com/en-us/ef/core/querying/raw-sql
* DbSet<MediaDate> set = context.Set<MediaDate>();
* mediaDateList = set.FromSql("[dbo].[sp_GetMediaDate]").Select(x => new SelectListItem { Text = x.DateText, Value = x.DateValue }).ToList();
*/
using (var cnn = context.Database.GetDbConnection())
{
var cmm = cnn.CreateCommand();
cmm.CommandType = System.Data.CommandType.StoredProcedure;
cmm.CommandText = "[dbo].[sp_GetMediaDate]";
cmm.Connection = cnn;
cnn.Open();
var reader = cmm.ExecuteReader();
while (reader.Read())
{
MediaDate mediaDate = new MediaDate();
mediaDate.DateText = Convert.ToString(reader["DateText"]);
mediaDate.DateValue = Convert.ToString(reader["DateValue"]);
mdList.Add(mediaDate);
}
}
mediaDateList = mdList.Select(x => new SelectListItem {
Text = x.DateText, Value = x.DateValue
}).ToList();
return(mediaDateList);
}
