Using MySQL with Entity Framework and ASP.NET MVC \u2013 Part I<\/a><\/p>\nIn Part I, we created a database schema in MySQL, generated a data model using Entity Framework, and wrapped the model using a simple repository pattern. We will now walk through using those repositories to access and modify our data.<\/p>\n
Extending our repositories<\/strike> data model<\/strong><\/p>\nDue to the fact that the default MySQL database engine does not support foreign keys, there is no relationship between the two entities generated by Entity Framework. After a frustrating experience trying to manually add the association for Product->Category using the EF designer, I decided to add it manually by extending the generated partial class. This will allow us to easily access the category to which a product belongs.<\/p>\n
\n
public partial class Product\n {\n private Category _category;\n\n public Category Category\n {\n get\n {\n if (_category == null)\n {\n var categoryRepository = new CategoryRepository();\n\n var cat = categoryRepository.Select(categoryid);\n\n _category = cat.First();\n }\n\n return _category;\n }\n } \n}\n<\/pre>\n <\/pre>\n<\/div>\n