zzz projects Entity Framework 6 EF 6
Home EF Core 5 Articles Knowledge Base Online Examples
  • Home
  • EF Core 5
  • Articles
  • Knowledge Base
  • Online Examples

Entity Framework 6 - Knowledge Base (KB)

11 results for: in tag: database-design

Can SQL Server views have primary and foreign keys?

Is it possible to define primary and foreign keys for database Views in Microsoft SQL Server Management Studio? How?...I'm trying to create an ADO.NET Entity Data Model to read from four old, poorly-formed database tables that I cannot modify. I've create...
.net ado.net-entity-data-model database-design entity-framework sql-server
asked by Zack Peterson

Entity Framework Endpoint Multiplicity

Say I have 3 tables in a Tennis Application (stripped down removing irrelevant info):...Competitions...Id (PK)...Matches...Id (PK)...CompId (FK)...CourtAssignments...CompId (PK),(FK)...CourtNumber (PK)...MatchId (FK), (Unique)...To describe the above: A m...
database-design entity-framework
asked by Scott

Best pattern for storing (product) attributes in SQL Server

We are starting a new project where we need to store product and many product attributes in a database. The technology stack is MS SQL 2008 and Entity Framework 4.0 / LINQ for data access....The products (and Products Table) are pretty straightforward (a...
database database-design entity-framework sql sql-server
asked by EdH

What does principal end of an association means in 1:1 relationship in Entity framework

public class Foo { public string FooId{get;set;} public Boo Boo{get;set;} } public class Boo { public string BooId{get;set;} public Foo Foo{get;set;} } ...I was trying to do this in Entity Framework when I got the error:...Unable to dete...
c# database-design entity-framework foreign-key-relationship
asked by taher chhabrawala

thread messaging system database schema design

I'm trying to achieve exactly what's explained here: ...Creating a threaded private messaging system like facebook and gmail..., however i don't completly understand Joel Brown's answer. can any one please explain....This is what my db tables look like ...
asp.net database database-design entity-framework linq
asked by ShaneKm

What are the best practices for using a GUID as a primary key, specifically regarding performance?

I have an application that uses GUID as the Primary Key in almost all tables and I have read that there are issues about performance when using GUID as Primary Key. Honestly, I haven't seen any problem, but I'm about to start a new application and I still...
database-design entity-framework guid primary-key sql-server
asked by VAAA

How to create a model using .edmx designer in visual studio 2012?

I'm new with Entity Framework 5.0. I'm looking for a tutorial on how to create a DB model using the .edmx designer in visual studio 2012.
database-design edmx-designer entity-framework visual-studio-2012
asked by user1019042

How entity framework works for large number of records?

I see already a un-answered question ...here on.......My question is -...Is EF really production ready for large application?...The question originated from these underlying questions -...EF pulls all the records into memory then performs the query operat...
c# database-design entity-framework entity-framework-6
asked by Abhijeet

Entity Relationship Diagram for Hotel

I need to create an ERD for a hotel, the question reads as follows:..."...The owner of a set of hotels would like to have a hotel management system built for his or her hotels. The hotels are located in major cities and tourist attraction areas of South ...
database-design entity-framework entity-relationship erd sql
asked by Marilee

Authorize data access at database level

From the question title you might guess what is this about. I'll try to describe what I currently have and what I want to archive....Suppose an application that handles four entities: ...User..., ...Team..., ...Repository... and ...Document.... The relati...
asp.net-mvc-5 authorization c# database-design entity-framework-6
asked by rareyesdev

EF6 code first multiple 1-to-many mapping issue / "Multiplicity" error

I am receiving the following error when attempting to create the database:...One or more validation errors were detected during model generation:...Interaction_CauseElement_Source: : Multiplicity is not valid in Role 'Interaction_CauseElement_Source' in...
c# database-design ef-code-first entity-framework entity-framework-6
asked by jwatts1980

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now