Introduction
KiGG is a Web 2.0 style social news web application developed in Microsoft supported technologies. It is an open source project hosted on CodePlex. It is live and running as DotNetShoutout.com.
KiGG and Entity Framework
On May 2009, I’ve completed the implementation of Entity Framework support on KiGG. KiGG design was very flexible to plug another repository implementation other than LINQ to SQL. So basically now KiGG comes with 2 repository flavours, LINQ to SQL and Entity Framework.
Read about how to configure your KiGG application to use Entity Framework.
KiGG and MySQL
After Entity Framework implementation is completed, I wanted to gain benefit of it. I wanted to support multiple databases using Entity Framework without changing the code!
Entity Framework Entity Data Model (EDM) separate storage model (SSDL) from conceptual model (CSDL). The Conceptual model mustn’t be touched under any circumstances. Only storage model (SSDL) is subject to change because it is couple with underlying data provider and database engine.
My first candidate database engine was MySQL. And successfully added support to MySQL using MySQL Connector/net.Net Data Provider for MySQL (free) and Devart .Net Data Provider for MySQL (commercial)
Read about how to configure KiGG to use MySQL database.
IMPORTANT NOTE:
I modified MySQL Connector/net code to fix few issues related to LINQ to Entities, Entity SQL and Guid support. KiGG do not support the provider released by MySQL Connector/net, instead use the modified version.
Soon I will blog about how to target different database engines using Entity Framework in single application so stay tuned.
KiGG Entity Framework and MySQL Support How-To:
I wrote couple of articles -detailed- on project wiki as documentation. Feel free to reference those articles in order to configure your KiGG application to use Entity Framework and MySQL: