From MSDN: Error 11007: Entity Type Is Not Mapped This error occurs when an entity type in the conceptual model is not mapped to the data source. To resolve this error, map the entity type to the data source. Look at the MSDN link How to: Map Entities to Database Tables
An InMemory provider is included in EF7 (pre-release). You can use either the NuGet package, or read about it in the EF repo on GitHub (view source).
Sure. Projection does this: var q = from r in Context.TableName select new { Id = r.Id, Status = r.Status } Here’s an actual example (obviously, my DB has different tables than yours). I added my EF model to LINQPad and typed the following query: from at in AddressTypes select new { Id = at.Id, … Read more
You cannot achieve it directly because neither eager or lazy loading in EF supports ordering or filtering. Your options are: Sort data in your application after you load them from database Execute separate query to load child records. Once you use separate query you can use OrderBy The second option can be used with explicit … Read more
I would suggest Disable Proxy Creation only in the place where you don’t need or is causing you trouble. You don’t have to disable it globally you can just disable the current DB context via code… [HttpGet] [WithDbContextApi] public HttpResponseMessage Get(int take = 10, int skip = 0) { CurrentDbContext.Configuration.ProxyCreationEnabled = false; var lista = … Read more
The following will probably cause sunspots and overthrow western civilization. It may even cause a debate about Duct Tape Programming (make it stop!), but it works (for now) try { var dataSet = ConfigurationManager.GetSection(“system.data”) as System.Data.DataSet; dataSet.Tables[0].Rows.Add(“SQLite Data Provider” , “.Net Framework Data Provider for SQLite” , “System.Data.SQLite” , “System.Data.SQLite.SQLiteFactory, System.Data.SQLite”); } catch (System.Data.ConstraintException) { … Read more
Very late to your question, I had the same issue and discovered that the entity framework designer had identified my “ScoreId” column (relative to your PersonModelScore table) as a primary key column. I changed my setting to false for my ScoreId, and all worked well afterward.
If you want to use entities to seed data you should use Seed method in your migrations configuration. If you generate fresh project Enable-Migrations you will get this configuration class: internal sealed class Configuration : DbMigrationsConfiguration<YourContext> { public Configuration() { AutomaticMigrationsEnabled = false; } protected override void Seed(CFMigrationsWithNoMagic.BlogContext context) { // This method will be … Read more
I also faced with similar problem and found the following solution // Entity Framework Core public virtual int GetKey<T>(T entity) { var keyName = Context.Model.FindEntityType(typeof (T)).FindPrimaryKey().Properties .Select(x => x.Name).Single(); return (int)entity.GetType().GetProperty(keyName).GetValue(entity, null); }
CREATE PROCEDURE [MySPROC] AS BEGIN –supplying a data contract IF 1 = 2 BEGIN SELECT cast(null as bigint) as MyPrimaryKey, cast(null as int) as OtherColumn WHERE 1 = 2 END CREATE TABLE #tempSubset( [MyPrimaryKey] [bigint] NOT NULL, [OtherColumn] [int] NOT NULL) INSERT INTO #tempSubset (MyPrimaryKey, OtherColumn) SELECT SomePrimaryKey, SomeColumn FROM SomeHugeTable WHERE LimitingCondition = true … Read more