System.InvalidOperationException: The type MyContext+Northwind was not mapped.

简介:

System.InvalidOperationException: The type MyContext+Northwind was not mapped. Check that the type has not been explicitly excluded by using the Ignore method or NotMappedAttribute data annotation. Verify that the type was defined as a class, is not primitive, nested or generic, and does not inherit from EntityObject.

错误原因:

 entity framework不能将内部类与数据库匹配。

错误代码如下所示:

复制代码
 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using System.Data.Entity;
 6 using System.ComponentModel.DataAnnotations;
 7 
 8 namespace TestCodeFirst
 9 {
10     public class MyContext
11     {
12         public class Product
13         {
14             public int ProductID { get; set; }
15             public int CategoryID { get; set; }
16             [Required(ErrorMessage = "Product Name不能为空")]
17             public string ProductName { get; set; }
18             public Decimal? UnitPrice { get; set; }
19             public bool Discontinued { get; set; }
20             public virtual Category Category { get; set; }
21         }
22 
23         public class Category
24         {
25             public int CategoryID { get; set; }
26             public string CategoryName { get; set; }
27             public string Description { get; set; }
28             public byte[] Picture { get; set; }
29             public virtual ICollection<Product> Product { get; set; }
30         }
31         public class Northwind : DbContext
32         {
33             public DbSet<Product> Products { get; set; }
34             public DbSet<Category> Categorys { get; set; }
35         }
36     }
37 }
复制代码


解决的办法:Northwind作为内部类。正确的代码如下所示

复制代码
 1 namespace TestCodeFirst
 2 {
 3        public class Product
 4        {
 5            public int ProductID { get; set; }
 6            public int CategoryID { get; set; }
 7              [Required(ErrorMessage="Product Name不能为空")]
 8            public string ProductName { get; set; }
 9            public Decimal? UnitPrice { get; set; }
10            public bool Discontinued { get; set; }
11            public virtual Category Category { get; set; }
12        }
13 
14        public class Category
15        {
16            public int CategoryID { get; set; }
17            public string CategoryName { get; set; }
18            public string Description { get; set; }
19            public byte[] Picture { get; set; }
20            public virtual ICollection<Product> Product { get; set; }
21        }
22        public class Northwind:DbContext
23        {
24            public DbSet<Product> Products { get; set; }
25            public DbSet<Category> Categorys { get; set; }
26     }
27 }
复制代码

 

 

 


作者:kissazi2 
出处:http://www.cnblogs.com/kissazi2/ 
本文版权归作者所有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。

转载:http://www.cnblogs.com/kissazi2/archive/2013/01/04/2843944.html

目录
相关文章
|
3月前
|
Docker 容器
成功解决:Caused by: ParsingException[Failed to parse object: expecting token of type [START_OBJECT] but
这篇文章讨论了在使用Docker启动Elasticsearch容器时遇到的一个具体问题:由于配置文件`elasticsearch.yml`解析出错导致容器启动失败。文章提供了详细的排查过程,包括查看容器的日志信息、检查并修正配置文件中的错误(特别是空格问题),并最终成功重新启动了容器。
### Cause: java.sql.SQLException: Field ‘id‘ doesn‘t have a default value; Field ‘id‘ doesn‘t have
### Cause: java.sql.SQLException: Field ‘id‘ doesn‘t have a default value; Field ‘id‘ doesn‘t have
|
6月前
|
API Android开发 开发者
failed to set system property error code: 0x18
failed to set system property error code: 0x18
266 1
|
人工智能 自然语言处理 语音技术
Invalid prop: type check failed for prop “index“. Expected String with value “5“问题解决
Invalid prop: type check failed for prop “index“. Expected String with value “5“问题解决
115 0
|
SQL Java 数据库连接
attempted to return null from a method with a primitive return type
attempted to return null from a method with a primitive return type
178 0
‘gperf‘ is missing on your system.
‘gperf‘ is missing on your system.
185 0
解决办法:Type safety: The expression of type List needs unchecked conversion to conform
解决办法:Type safety: The expression of type List needs unchecked conversion to conform
316 0
|
关系型数据库 MySQL 数据库
当你遇到Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value:
当你遇到Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value:
'gperf' is missing on your system.
'gperf' is missing on your system.
107 0