Design models and db configuration for Entity Framework code first project


We have an application where we can search for events. The search form has various parameters that can be saved to the db.

For example:

Date and Keyword plus multi selections of countries and states.

Please can you design the code first models and db configuration for Entity Framework using C#.


Each saved search is stored into this table


Id (int) PK

Name (string)

StartDate (DateTime)

EndDate (DateTime)

The collection types are stored in this table (Countries, States, etc..)


Id (int) PK

Type (string)

Description (string)

Each selection is stored in this table. This references the saved search where there is many selections for each saved search


Id (int) PK

SavedSearchId (int) FK => SavedSearch Table

SearchCollectionTypeId (int) FK => SearchCollectionTypes Table

FilterItem (int)

Please use fluent api to configure the relationships.

Here is a sample saved search that would be provided to the controller

Property Value Type

Id 1 (Int32)

Name Test Search (String)

Start Date 07 March 2018 (DateTime)

End Date 07 April 2018 (DateTime)

Countries [1,2,3,4,5,6,7] (Collection)

States [1,2,3] (Collection)

Please let me know if you require more details.

Kemahiran: .NET, Pengaturcaraan C#, Kejuruteraan Perisian

Lihat lagi: entity framework code first existing database, entity framework code first vs database first, entity framework code first connection string, entity framework code first create database, entity framework database first tutorial, entity framework code first create database if not exist, entity framework code first migrations, code first entity framework example, entity framework code first, code first entity framework, code project application configuration, project design models, start state goal state puzzle search java code, project entity framework interview questions, entity framework level design, code project design chat voice use vb6, code project site design php html, code project digital design, free code project cad robotics system programming, code project pci card control

Tentang Majikan:
( 1 ulasan ) Poole, United Kingdom

ID Projek: #16441016

Dianugerahkan kepada:


Dear client, I can design code first db models. I have more than 8 years of experience in software development and web development using Microsoft technologies. I have expertise in ASP.NET, [login to view URL], WPF, Lagi

£17 GBP dalam sehari
(22 Ulasan)

7 pekerja bebas membida secara purata £17 untuk pekerjaan ini


Hi, I have more than 6 years of experience in web and windows applications. I will create a windows form with search criteria. Create a facade class in C# which will access the database and display the result on the s Lagi

£18 GBP dalam 2 hari
(2 Ulasan)

Since December 2011, have around 6 year of extensive hands on experience of design, developing and deployment n-tier web based applications using .Net platform. • Extensive experience in Web based application developm Lagi

£18 GBP dalam sehari
(4 Ulasan)

Hi there, I have read your full description. I believe, I have the ability to full fill your demand . I have done several projects in entity framework code first approach. please, visit my portfolio, you will get som Lagi

£18 GBP dalam sehari
(3 Ulasan)

we have a huge group of developers with around >3 years of experience in the technologies which are needed to complete this project. and we can assure you that the project will be completed in the given time period. Lagi

£23 GBP dalam 7 hari
(1 Ulasan)

I have 5 years experience with .net technologies. I have 5 years experience with .net entity framework. I have worked with AspBolierplate Framework.

£13 GBP dalam sehari
(0 Ulasan)

Dear Project Manager, I have gone through your job description and glad to inform you that I am willing to work on your assignment, I do understand the scope of your job and I'm well experienced in Dot Net develop Lagi

£13 GBP dalam sehari
(0 Ulasan)