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

c# entity-framework-6 telerik-grid

Question

I'm trying to filter the results from an entity, but when I put two where conditions before the load it'll only filter by the first condition like so 

      _entity.LineItems.Where(x =>( x.EstID == Est.EstID) && (x.LineItemType == 1)).Load();
      radLaborLineItems.DataSource = _entity.LineItems.Local.ToBindingList();

Also tried it like this with the same results

     _entity.LineItems.Where(x => x.EstID == Est.EstID).Where(y => y.LineItemType == 1).Load();
     radLaborLineItems.DataSource = _entity.LineItems.Local.ToBindingList();

In the above examples since the results are only getting filtered by the first condition I'm able to add new rows, or in other words read only is false. But when I split the conditions out, one on the load and one on the ToBindingList like this...

     _entity.LineItems.Where(x => x.EstID == Est.EstID).Load();
     radLaborLineItems.DataSource = _entity.LineItems.Local.ToBindingList().Where(y => y.LineItemType == 1);

The result is being filtered by both conditions, but I cant add a new row because of a data exception that says collection is read only. I've even tried manually setting the readonly and AllowAddNewRow properties, but still get a readonly error when trying to add a new row.

     radLaborLineItems.ReadOnly = false;
     radLaborLineItems.AllowAddNewRow = true;

So my question is how can I filter an entity by multiple conditions and still have the add new row functionality?

Also worth noting that the results are being bound to a telerik radGridView

1
0
4/10/2020 4:57:25 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

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 = lineItemList;
0
4/10/2020 5:29:06 PM

Related Questions

How do I choose entities using a where condition on their entitycollection in Linq to Entities?

Instead of using the type Company, have you tried selecting a new anonymous type:...Return context.Companies.Include("Employees").Select(c => New With { .Id = c.Id, .Employees = c.Employees.Where(Function(e) e.Age > 24) }).ToList() ...(Sorry if the syntax is a little off, it's been a while since I've done LINQ/Anonymous Types in VB.NET)
eager-loading entitycollection entity-framework linq-to-entities one-to-many
asked by Justin Niessner

Selective Condition on Included Navigation Property in Entity Framework

You can't selectively pull back certain child entities that match a certain condition. The best you can do is manually filter out the relevant orders yourself....public class PurchaseOrder { public int POID {get;set;} public int OrderID {get;set;} public int VendorID {get;set;} public IEnumerable<Order> Orders {get;set;} ...
c# entity-framework linq navigation-properties
asked by Adam Rackis

In System.Data.Entity.dll (Entity Framework), why am I receiving a NullReferenceException?

If it's only for Nevada then it must be a data problem, do a thorough check in the db....And to summarize, the core problem was: ...It was db-first. ...... was returning a null value for one of the fields that was marked in EF as not null
c# entity-framework wpf
asked by Henk Holterman

Entity Framework: how to solve "FOREIGN KEY constraint may cause cycles or multiple cascade paths"?

You can use the fluent api to specify the actions the error message suggests....In your Context:...protected override void OnModelCreating( DbModelBuilder modelBuilder ) { base.OnModelCreating(modelBuilder); modelBuilder.Entity<aspnet_UsersInRoles>().HasMany(i => i.Users).WithRequired().WillCascadeOnDelete(false); } ...Note that you...
asp.net entity-framework sqlmembershipprovider
asked by Charles

Linq to Entity Join table with multiple OR conditions

You don't have to use the join syntax. Adding the predicates in a ...where... clause has the same effect and you can add more conditions:...var query = (from RR in context.TableOne from M in context.TableTwo where RR.OrderedProductId == M.ProductID || RR.SoldProductId == M.ProductID // Your join ...
c# entity-framework linq linq-to-entities
asked by Gert Arnold

Entity Framework will only set related entity property to "null" if I first get the property

Edit... This seems to occur for ...any... Entity property that references another entity in one direction. In other words, for the below example, the fact that ...Bar... overrides Equality appears to be irrelevant....Suppose I have the following classes:...public class Foo { public int? Id { get; set; } public virtual Bar { get; set; } }...
c# entity-framework entity-framework-6
asked by Nathan

How to Add a read-only Property to Database first Entity Framework 6 metadata

If the FullName column doesn't exist in the database table which means no property FullName exists in your EF model Student class you'll get this error....I doubt you can achieve what you want using metadata-approach. But you can modify the way your properties are rendered in a view. If the following is your EF model class:...public partial class S...
asp.net asp.net-mvc c# entity-framework-6
asked by sergik

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

Not sure if that's the root cause of the problem, but there is a subtle difference between those two queries - the relative position of OrderBy and Where. In relational world, filter invalidates sorting done in the subquery. EF tries to compensate for this discrepancy by "lifiting" some of the orderbys after the filter, and perhaps is unable to lif...
entity-framework-6 linq-to-sql sql-server
asked by Maurycy

Entity Framework insert object with multiple navigation properties of same type and id

I have read several posts about this (e.g. ...Why can't EF handle two properties with same foreign key, but separate references/instances?...) issue but none provided a satisfying solution....Using EF6, inserting an object with two navigation properties fails, when the properties have the same type, represent the same entry (i.e. have the same prim...
c# entity-framework entity-framework-6
asked by Abid

Set value of property in IQueryable<T> after join with another table based on some conditions

I am implementing Authorization for WPF. I have bound permissions with screens. For example, there is a screen called floor. It has four permissions associated with it....View Floor ...Add Floor...Edit Floor...Delete Floor...Along with every permission we have four levels of permissions....All...Self...Role...User...So, if users have {View Floor} p...
automapper entity-framework entity-framework-6 iqueryable linq
asked by Safi Mustafa

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