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); }