Lengkap

Design models and db configuration for Entity Framework code first project

Intro

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#.

Models

Each saved search is stored into this table

SavedSearch

Id (int) PK

Name (string)

StartDate (DateTime)

EndDate (DateTime)

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

SearchCollectionTypes

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

SavedSearchCollections

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:

mkmomy

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)
4.9

7 pekerja bebas membida secara purata £17 untuk pekerjaan ini

RaghavendravDesh

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)
4.0
saytechworld

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)
2.9
sharpinterface

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)
1.8
shaliniramadass

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)
1.1
kumarsun0002

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)
0.0
barmalasharma

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)
0.0