Retrieve an object from entityframework without ONE field

by

Is there a way to retrieve a List but without this column filled?

Not without projection which you want to avoid. If the column is mapped it is natural part of your entity. Entity without this column is not complete – it is different data set = projection.

I’m using here the anonymous type because otherwise you will get a
NotSupportedException: The entity or complex type ‘ProjectName.File’
cannot be constructed in a LINQ to Entities query.

As exception says you cannot project to mapped entity. I mentioned reason above – projection make different data set and EF don’t like “partial entities”.

Error 16 Error 3023: Problem in mapping fragments starting at line
2717:Column Files.Data in table Files must be mapped: It has no
default value and is not nullable.

It is not enough to delete property from designer. You must open EDMX as XML and delete column from SSDL as well which will make your model very fragile (each update from database will put your column back). If you don’t want to map the column you should use database view without the column and map the view instead of the table but you will not be able to insert data.

As a workaround to all your problems use table splitting and separate the problematic binary column to another entity with 1 : 1 relation to your main File entity.

More Related Contents:

  1. Join and Include in Entity Framework
  2. What is the syntax for an inner join in LINQ to SQL?
  3. Decimal precision and scale in EF Code First
  4. How can I automatically filter out soft deleted entities with Entity Framework?
  5. EntityType has no key defined error
  6. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  7. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  8. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  9. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  10. Insert data using Entity Framework model
  11. Entity Framework error: Cannot insert explicit value for identity column in table
  12. How to get property change notifications with EF 4.x DbContext generator
  13. Does using parameterized SqlCommand make my program immune to SQL injection?
  14. Executing query with parameters
  15. How to disable cascade delete for link tables in EF code-first?
  16. Entity Framework – Cannot convert lambda expression to type ‘string’ because it is not a delegate type
  17. Internal .NET Framework Data Provider error 1025
  18. SqlConnection.Close() inside using statement
  19. Include with FromSqlRaw and stored procedure in EF Core 3.1
  20. Get affected rows on ExecuteNonQuery
  21. Global setting for AsNoTracking()?
  22. EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata
  23. Remove item from list based on condition
  24. Check if a SQL table exists
  25. Issues Doing a String Comparison in LINQ
  26. Unable to find the requested .Net Framework Data Provider. It may not be installed
  27. How to include() nested child entity in linq
  28. The ObjectContext instance has been disposed and can no longer be used for operations that require a connection [duplicate]
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. How can set a default value constraint with Entity Framework 6 Code First?

Leave a Comment