Where are the SQL Server database schema patterns – how about EF code-first as a solution?

If you've worked in software development for several years, you've probably noticed that many SQL database table design patterns repeat and repeat themselves in almost every project you begin working on. For instance, application logging, history collection of events and processes, and the storage of "customer" information can in many cases be implemented using very closely similar ways from app to app.

With this in mind, it's interesting to note that there aren't many places where you could download or copy ready-made database structures, like you can download and copy many coding patterns. Database patterns just aren't available in the same volume. The same applies to Visual Studio gallery for instance: most everything is code, but database patterns in itself are rare.

Here's an idea: since NuGet is a great way to get up to speed quickly with libraries, why couldn't there be NuGet packages that simply contain models for Entity Framework code-first classes for common business scenarios? With EF 6 (the latest version), you could install the NuGet package to your project, and then create your SQL Server database based on the code.

What do you think of this idea? Let your voice be heard!