dbset does not contain a definition for where
entity framework select where id in list
ef core dbset find
ef core firstordefault
entity framework select all to list
select query in entity framework in c#
dbset count
dbset in c#

I'm trying to do this but it says I can't use FirstOrDefault,

public static int GetId(this Context db, Type type, string name)
    return db.Set(type).FirstOrDefault(x => x.Name == name).Id;

The error is 'System.Data.Entity.DbSet' does not contain a definition for 'FirstOrDefault' and no extension method 'FirstOrDefault' accepting a first argument of type 'System.Data.Entity.DbSet' could be found (are you missing a using directive or an assembly reference?)

I then tried this Cast method but that gave an error Cannot create a DbSet from a non-generic DbSet for objects of type 'WindowStyle' (btw WindowStyle inherits from DomainEntity below),

var set = db.Set(type).Cast<DomainEntity>();
return set.FirstOrDefault(x => x.Name == name).Id;

Here is the class,

public class DomainEntity
    public virtual int Id { get; set; }
    public virtual string Name { get; set; }

This answer possibly doesn't help you depending on how "dynamic" the situation is where you call this method, basically if you know the type at compile time or not. If you know it you can write a generic method instead:

public static class MyExtensions
    public static int? GetId<TEntity>(this Context db, string name)
        where TEntity : DomainEntity
        return db.Set<TEntity>()
            .Where(x => x.Name == name)
            .Select(x => (int?)x.Id)

I've changed it to a projection because you don't need to load the full entity if you only want the Id. You can let the database do the work to select the property to improve performance a bit. Also I return a nullable int in case that there is no match for the name in the database.

You can call this in your code like so:

int? id = db.GetId<WindowStyle>("abc");

As you can see for this solution you must specify the type WindowStyle at compile time.

This assumes that DomainEntity is not part of your model (there is no DbSet<DomainEntity>), but just a base class of your entities. Otherwise @Paul Keister's solution would be easier.


Alternatively you can also try the following:

public static class MyExtensions
    public static int? GetId(this Context db, Type entityType, string name)
        return ((IQueryable<DomainEntity>)db.Set(entityType))
            .Where(x => x.Name == name)
            .Select(x => (int?)x.Id)

And call it:

int? id = db.GetId("abc", someType);

It will throw an exception though at runtime if someType does not inherit from DomainEntity. The generic version will check this at compile time. So, if you can prefer the first version.

Querying data via the DbSet, This answer possibly doesn't help you depending on how "dynamic" the situation is where you call this method, basically if you know the type at compile time or  Find Method. Finding the row with the Primary Key is one of the common tasks that we perform on a table. The DbContext gives us the Find Method to do just that. The DbSet exposes the Find method, which uses the Primary Key to return the entity matching the primary key.

Maybe you are missing

using System.Linq;

Queryable.FirstOrDefault Method (System.Linq), Returns the first element of a sequence, or a default value if no element is found. In this article. Definition; Overloads; FirstOrDefault<TSource>(IQueryable<  zooDbContext.Employees.FirstOrDefault(e => e.FirstName == "xx") will retrieve all records from employees collection in mongodb. Reproduce step: Open mongo shell and use the command "db.setProfilingLevel(2)" to open the query profiler.

The first construct won't work because you are working with a non-generic DbSet, so you can't apply the FirstOrDefault extension method, which only works with a generic. It sounds like you understand that already, because you're already trying to get the non-generic DbSet. The error you're getting with the Cast() method is caused by your attempt to cast a DbSet to a DbSet. This can't be allowed, because if it were it would be possible to add non-conforming members to the DbSet (objects of type other than WindowsStyle). Another way of saying this is that Covariance is not supported for DbSets because DbSets allow additions.

I think you'll have to find another way to do what you're trying to do. Mixing LINQ and inheritance this way obviously problematic. Since you have a base type defined, and you're only working with attributes that are available on the base type, why not just query the base type?

    public static int GetId(this Context db, string name)
        return db.DomainEntities.FirstOrDefault(x => x.Name == name).Id;

You're probably worried about name collisions between the various types, but you can probably start with this and look at the derived type associations to verify that you're looking at the correct type. One way to deal with this is to add a type flag to your DomainEntity definition.

DbSet<TEntity> Class, A DbSet represents the collection of all entities in the context, or that can be queried from the database, of a given type. DbSet objects are created from a  The FirstOrDefault () method returns a first specific element of a sequence or default value if that element is not found in the sequence. Whenever FirstOrDefault is used, the query can return any amount of results but you state that you only want the first one. I create a console application to explain the differences between these methods.

Here's the issue. The DbSet class has its own implementation of Cast<T>() that ONLY allows database types (such as Cast<WindowStyle>()), so this method does not allow Cast<DomainEntity>() and is throwing the exception.

Instead, you want to use the IQueryable.Cast<T>() extension method, which will simply cast your data to the base type. Here's an example:

var set = ((IQueryable)db.Set(type)).Cast<DomainEntity>();
return set.First(x => x.Name == name).Id;

Single, SingleOrDefault, First, FirstOrDefault in Entity Framework , The DbSet exposes the Find method, which uses the Primary Key to return the entity matching the primary key. 1. 2. 3. 4. 5. 6. 7. DbSet in Entity Framework 6. The DbSet class represents an entity set that can be used for create, read, update, and delete operations.. The context class (derived from DbContext) must include the DbSet type properties for the entities which map to database tables and views.

Here is an idea I had that seems to be working.

public static int GetId(this Context db, Type type, string name)
    var set = db.Set(type);
    foreach (dynamic entry in set)
        if (entry.Name == name)
            return entry.Id; 

[SOLVED] DbSet.FirstOrDefault()?, This answer possibly doesn't help you depending on how "dynamic" the situation is where you call this method, basically if you know the type at compile time or  Data querying in Entity Framework Core is performed against the DbSet properties of the DbContext. The DbSet represents a collection of entities of a specific type - the type specified by the type parameter.

System.Data.Entity.DbSet<Entities.User>' does not contain a , For some reason in this code here is giving me an error, but the method FirstOrDefault works fine in other entities User user = context.Users. You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. to refresh your session.

DbSet.FirstOrDefault()?, DbSet.FirstOrDefault()?. Я пытаюсь сделать это, но он говорит, что я не могу использовать FirstOrDefault, public static int GetId(this Context db, Type type,  Entity Framework (EF) is a data access layer (DAL) that allows for easily accessing a database for your create, read, update, and delete (CRUD) actions. If you use Entity Framework, you don’t…

c# - DbSet.FirstOrDefault()?, Esta respuesta posiblemente no le ayuda en función de cómo "dinámica" la situación es cuando se llama a este método, básicamente, si se conoce el tipo en  Entity Framework - Update without Select. GitHub Gist: instantly share code, notes, and snippets.

  • Do you have using System.Linq at the top of your file? DbSet inherits IEnumerable but the LINQ functions are all Extension methods and will not be available without the using statement.
  • Is your second error (Cast) a compile-time or run-time error? That will make a big difference, and it's hard to infer from your question.
  • @Chris, yes I did. Good question.
  • @Scott, It was run-time, showing up in my browser.
  • If I could give you all my reputation here, I would - this is what I'm looking for about an half year and I always did wrong approach. Thx, you are really my god now.
  • I forgot to make sure that System.Linq was in the usings! It's almost always there by default, and I never thought to check for it.
  • and what happens here if your object is null and you try to reference id : )
  • Paul, Thanks. But I don't have a DbSet<DomainEntity> on the DbContext. Is that why I'm having a problem? I was just using DomainEntity to organize other classes by inheritance. I think the real problem is I don't understand generics.
  • I tried using MakeGenericType but it said DbSet<DomainEntity> is not a generic type.
  • The DbSet will retrieve entities from the database. So if you don't have a separate database table for the DomainEntity entity, this approach will fail. Using DB first, this can definitely be done. It sounds like you're using code first; I've never done this with code first but it should be possible. In any case, you will need a DomainEntity DbSet. On the database side, inheritance can be modeled by making the primary key for derived entities also a foreign key to the id of the parent entity.
  • You should be able to replace dynamic with DomainEntity here, which will give you nearly the same as my answer.
  • Loading a full table into memory (perhaps 1 million rows) to get just a single Id looks very uncool. The start of your loop will execute the query set with no filter at all. Stay away from this solution.
  • @Slauma, besides, he returns the match after iterating the entire table :) post edited.
  • I think I tried Where but it had the same problem as FirstOrDefault. Thanks.
  • This does fix a problem (improper use of FirstOrDefault), but it's unrelated to the question.