public IEnumerable <MediaFile> GetAll() { using (var context = new MediaFileContext()) { return(context.Media.AsNoTracking().ToList()); } //string queryString = "SELECT Name, Size, Duration FROM dbo.Media;"; //using (SqlConnection connection = new SqlConnection(@"Server=(localdb)\mssqllocaldb;Database=MediaInfos;Trusted_Connection=True;")) //{ // SqlCommand command = new SqlCommand(queryString, connection); // connection.Open(); // SqlDataReader reader = command.ExecuteReader(); // Console.WriteLine("From DB:"); // while (reader.Read()) // { // Console.WriteLine($"Name: {reader[0]} / Size: {reader[1]} / Duration: {reader[2]}"); // } // reader.Close(); //} }
public void Import(IEnumerable <MediaFile> medias) { using (var context = new MediaFileContext()) { context.Media.AddRange(medias); context.SaveChanges(); } }
public void Update(MediaFile mediaFile) { if (mediaFile.MediaID == 0) { using (var context = new MediaFileContext()) { context.Media.Add(mediaFile); context.SaveChanges(); } } else { //// attached //using (var context = new MediaFileContext()) //{ // var m = context.Media.FirstOrDefault(x => x.MediaID == mediaFile.MediaID); // if (m != null) // { // m.Duration = mediaFile.Duration; // m.Size = mediaFile.Size; // } // context.SaveChanges(); //} // detached using (var context = new MediaFileContext()) { var m = new MediaFile() { MediaID = mediaFile.MediaID }; var entry = context.Attach <MediaFile>(m); entry.State = EntityState.Unchanged; m = entry.Entity; m.Duration = mediaFile.Duration; m.Size = mediaFile.Size; context.SaveChanges(); } //using (SqlConnection connection = new SqlConnection(@"Server=(localdb)\mssqllocaldb;Database=MediaInfos;Trusted_Connection=True;")) //using (SqlCommand command = connection.CreateCommand()) //{ // command.CommandText = "UPDATE dbo.Media(Name, Size, Duration) VALUES (@name, @size, @duration) WHERE id = " + mediaFile.MediaID; // command.Parameters.AddWithValue("@name", mediaFile.Name); // command.Parameters.AddWithValue("@size", mediaFile.Size); // command.Parameters.AddWithValue("@duration", mediaFile.Duration); // connection.Open(); // command.ExecuteNonQuery(); // connection.Close(); //} } }