Save list to database entity framework

Question

I have the following code:

 internal static bool SaveUOSChangeLog(List<Contracts.DataContracts.UOSChangeLog> values, string user)
    {
        try
        {
            using(var ctx = new StradaDataReviewContext2())
            {
                values.ForEach(u => { u.Username = user; u.Changed = DateTime.Now; });
                var test = ctx.UOSChangeLog.Add(values);
                ctx.SaveChanges();
                return true;
            }
        }

The thing I want to do Is to save values to the database. However, I get a the following error message:

Here is my Contracts.DataContracts.UOSChangeLog:

   public int? Id { get; set; }
        public int Accident_nr { get; set; }
        public int Refnr { get; set; }
        public int Action { get; set; }
        public string Old_data { get; set; }
        public string New_data { get; set; }
        public DateTime SearchedFromDate { get; set; }
        public DateTime SearchedToDate { get; set; }
        public DateTime Changed { get; set; }
        public string Username { get; set; }
        public string Comment { get; set; }

And here Is my Services.StradaDataReview2Model.UOSChangeLog that are used as a DbSet

[Table("UOSChangeLog")]
    public partial class UOSChangeLog
    {
        [Required]
        public int? Id { get; set; }

        public int Accident_nr { get; set; }
        [Required]
        public int Refnr { get; set; }
        [Required]
        public int Action { get; set; }
        [Required]
        public string Old_data { get; set; }
        [Required]
        public string New_data { get; set; }
        [Required]
        public DateTime SearchedFromDate { get; set; }
        [Required]
        public DateTime SearchedToDate { get; set; }
        [Required]
        public DateTime Changed { get; set; }
        [Required]
        public string Username { get; set; }
        [Required]
        public string Comment { get; set; }
    }

your are trying to add a new List of specified class (values is a List) rather than a specific instance — apomene
– apomene, Commented Mar 17, 2016 at 13:37

Alexander Derck · Accepted Answer · 2016-03-17 13:43:26Z

7

You're trying to add a list with the Add method which takes a single object, just keep it simple and use a foreach:

using(var ctx = new StradaDataReviewContext2())
{
   foreach(var value in values)
   {
       value.Username = user;
       value.Changed = DateTime.Now;
       ctx.UOSChangeLog.Add(value);
   }
   ctx.SaveChanges();
   return true;
}

Just use a simple foreach, linq is a querying language, not a modifying language.

edited Mar 17, 2016 at 13:43

answered Mar 17, 2016 at 13:40

Alexander Derck

14.7k5 gold badges61 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Alexander Derck Over a year ago

@Bryan That's the best option, by using linq foreach you're not actually gaining anything

Bryan Over a year ago

Hi again, I still get the same error when doing like you do.

Alexander Derck Over a year ago

@Bryan value is of type UOSChangeLog right? Can you copy the error message?

Bryan Over a year ago

Here u can find a printscreen on the values of value list: postimg.org/image/56uxs9yzb and here you can find the error message: postimg.org/image/4felk4dir

Alexander Derck Over a year ago

@Bryan They're of different types. Your values are from Contracts.DataContracts namespace, and your objectcontext is Strada.DataReview... namespace. You'll have to create the right object to add it (of the Strada namespace).

|

Ellix4u · Accepted Answer · 2017-08-22 14:50:46Z

7

Please use addrange method.

db.TheTable.AddRange(TheList)
db.SaveChanges();

answered Aug 22, 2017 at 14:50

Ellix4u

6166 silver badges9 bronze badges

Comments

Dan Orlovsky · Accepted Answer · 2016-03-17 13:43:59Z

4

You can use Entity Framework's .AddRange method to add a collection of objects to your Db.

MSDN

It will look like:

       using(var ctx = new StradaDataReviewContext2())
        {
            values.ForEach(u => { u.Username = user; u.Changed = DateTime.Now; });
            var test = ctx.UOSChangeLog.AddRange(values);
            ctx.SaveChanges();
            return true;
        }

answered Mar 17, 2016 at 13:43

Dan Orlovsky

1,1139 silver badges19 bronze badges

5 Comments

Dan Orlovsky Over a year ago

List<T> implements IEnumerable MSDN - msdn.microsoft.com/en-us/library/6sh2ey19(v=vs.110).aspx -- Stack Overflow - stackoverflow.com/questions/4700613/…

Bryan Over a year ago

Ah okey. But I Still get same error described In my question.

Dan Orlovsky Over a year ago

Stupid question: your context does inherit DbContext, correct?

Austin_Anderson Over a year ago

@DanOrlovsky If I call List.Clear() after AddRange, will the db still have the data?

Dan Orlovsky Over a year ago

@Austin_Anderson - so long as you savechanges, you should be OK.

Collectives™ on Stack Overflow

Save list to database entity framework

3 Answers 3

8 Comments

Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related