A design for entity framework?

Question

0.00/5 (No votes)

See more:

, +

Could this design solution be solved by Entity Framework?

An app named "car parts" v1.0 has one user and incorporates a relational database with strongly typed columns for each of the 10 car parts that applies to the user's vehicle data.

The data is very searchable since it is in an indexed table.

Version 2.0 will have multiple users with different vehicles unknown at the time of release.

Following with this strong typed column model for each conceivable part for each new user and new car the data might have different names. Following along the relational strong typed column database design model for this new version brings up various design choices.

One approach might be to abandon strong typed columns. Another might be to attempt to create generic columns and use abstracted mapping tables to post-fit a new car part schema. Using the database to search the data seems to be a highly desired feature so that maintaining the data mapping in code initially appears less desirable although I suppose this is where LINQ comes in.

My questions are:
What does entity framework offer in this type of problem domain.
Or what other solutions might apply.

Posted 17-Apr-14 8:20am

Jeff Moeller

Updated 21-Apr-14 2:23am

thatraja

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 21-Apr-14 10:01am

Not quite clear. Is that the problem of your database schema which has fixed names of the file parts, that is, some fixed classifiers? And if such thing is a part of the schema, not database (part of metadata, not data), people won't be able to introduce new type of the part. Is that the problem?
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jeff Moeller · Accepted Answer · 2014-04-21T05:51:00

Solution 1

Thanks you Sergey, it turns out that my question is about hybrid EAV patterns with SQL Server on which I'd appreciate any further input.

Posted 21-Apr-14 5:51am

Jeff Moeller