This is a bunch of useful scripts for generating C# Entity Framework Code First POCOs from existing database schema.
First, let’s create T-SQL function for generating C# class for EF entity:
This function deliberately ignores certain columns, (Created On/By, Modified On/By). This properties are pushed to EntityBase class, which our POCO inherits from. All other columns in DB table will be mapped to corresponding C# type.
Next, let’s create T-SQL function for EF configuration (mapping class):
Now, let’s put it all together in one script:
All source code is available here