Click here to Skip to main content
14,775,067 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all
I have a database with no constreains and no relations. This is just a converted flat-file database and must not be touched.

I nead to create entities with relations and tryed this:

[Table("Customers")]
public class customer
{
    [Key, Column("CustoemrID")]
    public int Id{get;set;}

    [Column("CustomerName")]
    public string Name{get;set;}

    [Column("Zip")]
    public int Zip{get;set;}

    [ForeignKey("Zip")]
    public ZipCode{get;set;}
}
[Table("ZipCodes")]
public class ZipCode
{
    [Key, Column("ZipCode")]
    public int ZipCode{get;set;}
    
    [Column("Name")]
    public string Name{get;set;}
}


I get errors on this and wander if there are some other ways to do this
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900