Correct multiple condition for AddOrUpdate() in EF 6

.net c# entity-framework-6 insert-update

Question

Following statement in EF 6

db.ReceivedMessages.AddOrUpdate(r => r.PatientId == status.PatientId && 
                                    r.DialogId == status.ConversationId, record);

produces exception:

The properties expression 'r => Convert(((r.PatientId == Convert(value(ManagerDB+<>c__DisplayClass6_0).status.PatientId)) AndAlso (r.DialogId == value(ManagerDB+<>c__DisplayClass6_0).status.ConversationId)))' is not valid. The expression should represent a property: C#: 't => t.MyProperty' VB.Net: 'Function(t) t.MyProperty'. When specifying multiple properties use an anonymous type: C#: 't => new { t.MyProperty1, t.MyProperty2 }' VB.Net: 'Function(t) New With { t.MyProperty1, t.MyProperty2 }'.

Changed expression to:

 db.ReceivedMessages.AddOrUpdate(r => new { r.PatientId, r.DialogId }, record);

Got another exception:

The binary operator Equal is not defined for the types 'System.Nullable`1[System.Guid]' and 'System.Guid'.

How to use AddOrUpdate() properly to update by 2 columns: if PatientId-DialogId pair exists - update record, if not - insert new one?

1
3
6/28/2017 6:37:44 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Bug should be fixed in EF 6.2.0: https://github.com/aspnet/EntityFramework6/issues/9

Workaround: install EF beta version or insert-update like suggested in above comment:

ReceivedMessage record = db.ReceivedMessages.FirstOrDefault(p => p.PatientId == status.PatientId &&
                                                                    p.DialogId == status.ConversationId);
//  Add new if not exists
bool newRecord = false;
if (record == null)
{
    record = new ReceivedMessage();
    record.Id = Guid.NewGuid();
    newRecord = true;
}

// Save fields
// ...

// Save to DB
if (newRecord)  // Workaround for EF 6.1 bug: https://stackoverflow.com/a/44811951/630169
    db.ReceivedMessages.Add(record);
else
    db.Entry(record).CurrentValues.SetValues(record);

db.SaveChanges();
1
6/29/2017 1:17:39 AM

Related Questions

In EF, there are several where conditions.

Possible Duplicate:...Conditional Linq Queries...Using Entity Framework 4.0...I have a search condition like this...There are four fields that allow the users to filter their search. The conditions are all ...AND.... The result has to omit the corresponding filter if the textbox value is ...String.Empty... or the dropdownlist value is ...All.... Co...
asp.net c# entity-framework linq
asked by naveen

WHERE clause with many criteria in a LINQ query

I use EntityFramework with POCOs.... Suppose I have POCOs defined like this (simplified):...class Class1 { public int ID; public int SomeNumber; } class Class2 { public int ID; public int SomeNumber; } class Class3 { public int ID; public int SomeNumber; } class SomeClass { public int ID; public int? Class1ID; ...
entity-framework linq
asked by Dejan Janjušević

how to add multiple conditions in this lambda function?

I am working with EF generic repository and have this function....public IEnumerable<T> Query(Expression<Func<T, bool>> filter) { return objectSet.Where(filter); } ...It is working fine and before I have used this function in a class like this:... private void BindProbabationPeriod() { ddlProbabationPeriod.DataSource = c...
.net c# c#-4.0 entity-framework linq
asked by haansi

EF AddOrUpdate Seed does not Update Child Entities

No command in EF automatically updates child - ...AddOrUpdate... is no difference, it internally check existence of the top level entity (...Junk... in your case) and insert or update it if it doesn't exist. The insertion of children is a side effect in this case because when ...AddOrUpdate... internally calls ...Add... it adds whole object tree. ....
c# ef-migrations entity-framework
asked by Ladislav Mrnka

Linq to Entity Join table with multiple OR conditions

I need to write a Linq-Entity state that can get the below SQL query...SELECT RR.OrderId FROM dbo.TableOne RR JOIN dbo.TableTwo M ON RR.OrderedProductId = M.ProductID OR RR.SoldProductId= M.ProductID WHERE RR.StatusID IN ( 1, 4, 5, 6, 7 ) ...I am stuck with the below syntax... int[] statusIds = new int[] { 1, 4, 5, 6, 7 }; ...
c# entity-framework linq linq-to-entities
asked by HaBo

LINQ Join with multiple AND conditions

I want to join two entities in my MVC application for data Processing through the LINQ join....For that I am trying to write the query like,...from enumeration in db.Enumerations join cust in db.Customers on ( enumeration.Value equals cust.lkpStatus && enumeration.EnumerationTypeID.Contains('Cust') ...But I am getting Problem with this Query...
asp.net-mvc c# entity-framework linq linq-to-sql
asked by Rahul_RJ

OrderBy().FirstOrDefault(<condition>) vs. Where(<condition>).OrderBy().FirstOrDefault()

Im using EntitiyFramework 6.1.3 with SQL Server in a C# Project. I've two queries which basically should do the same....1....Exams.GroupBy(x=>x.SubjectID).Select(x => x.OrderBy(y => y.Level.NumericValue).FirstOrDefault(y => y.Date.Value > DateTime.Today)) ...2....Exams.GroupBy(x=>x.SubjectID).Select(x => x.Where(y => y.Date.Value > DateTime.Today)....
entity-framework-6 linq-to-sql sql-server
asked by Vanice

Linq Query With Multiple Joins Not Giving Correct Results

I have a Linq query which is being used to replace a database function. This is the first one with multiple joins and I can't seem to figure out why it returns 0 results....If you can see any difference which could result in the incorrect return it would be greatly appreciated......I've been trying to solve it longer than I should have....Linq Quer...
c# entity-framework entity-framework-6 linq
asked by Myles

EF 6.x AddorUpdate context fails on update

Your ...ExampleSchema... has conflicting data annotations on the ...Password... property:...[Required] [NotMapped] public string Password { get; set; } ...[Required]...:...The Required annotation tells EF that a particular property is required....[NotMapped]...Denotes that a property or class should be excluded from database mapping....It sound...
c# entity-framework-6
asked by devNull

Multiple where conditions on entity causes read only property to be true

var lineItemList = ( from e in _entity.LineItems where e.EstID == Est.EstID && e.LineItemType == 1 select new LineItemsModel{ e.EstId, e.LineItemType } ).ToList(); // -- Insert -- \\ lineItemList.Add(new LineItemsModel(){ EstId = 1, LineItemType = 2 }); radLaborLineItems.DataSource = lineIt...
c# entity-framework-6 telerik-grid
asked by Emre Can Kızılkiren

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow