The entity-framework tag has no wiki summary.
1
vote
2answers
71 views
Microsoft SQL Server how can i detach localdb to run on any computer
I am working on a personal project and have implemented a database system using the Entity Framework code first tutorial on msdn, link below,
http://msdn.microsoft.com/en-gb/data/jj193542
I am ...
1
vote
0answers
136 views
Can someone please give me hints on normalizing this database and any other helpful hints
I am using Entity Framework 5 to work with this database but I am getting issues with how tblTalkers and tblChatSessions are being mapped in the entity model when imported into Visual Studio. Please ...
5
votes
4answers
272 views
How to troubleshoot orm queries interfering with other applications
Well, it's hypothetical scenario but what I'm trying to understand is the path to go from a post-morten log (say, an SQL Server Profiler trace) to identify the code on a ORM situation. To make it not ...
1
vote
2answers
173 views
With MS SQL Server are the generated constraint names predictable?
When you create your primary key, and foreign key constraints in a CREATE TABLE script, there are named constraints that are created, such as FK__RecentlyVi__ScId__2764765D ... are these constraints ...
3
votes
1answer
252 views
Curious Database building Problem (ER Diagram)
I am trying to build an EER Model for a Autostore that has 5 locations and offers a range of auto products. They offer car repairs and roadworthy tests as a service also.
I need to be able to make ...
2
votes
1answer
115 views
Schema for 1 <-> 0..1(+), many related but only one primary
Using tools available in SQL Server 2008 and Entity Framework, what is a solid way to represent a one-to-many relationship, where there is an underlying unique relation that I need to enforce? My ...
3
votes
3answers
610 views
What should I consider when deciding between passing a comma-delimited string to a stored procedure instead of calling it individually per record?
I have to run the same stored procedure for a lot of records (hundreds or thousands, depending on user selection). The procedure is fairly basic: insert a record in two separate tables with some ...
1
vote
3answers
316 views
single select vs multiple selects using limit and offset
Working on a fairly high volume site. There are some tables example - the customers table which gets hit a lot.
The problem
We are writing a piece of code that selects a bunch of customers and ...
1
vote
1answer
136 views
Referring to super parent or as a separate entity?
I have this person table as super parent,
id
firstname
lastname
email
telephone
...
...
and user table as a child
id
person_id (FK)
password
username
screenname
...
...
They must be 1:1 ...
3
votes
3answers
934 views
NULLs in a composite primary key - SQL Server
I'm trying to work out the best way of creating SQL Server primary keys, foreign keys and constraints to accurately represent my data model in LINQ / Entity Data Objects. Let's assume - for the ...
2
votes
1answer
303 views
Will Entity Framework and/or Linq-To-SQL queries show up as “Adhoc Queries” in SSMS' “Server Dashboard” Report?
Its pretty much all in the title. I have a SQL Server which is showing that 90%+ of CPU Usage and Logical IO Performed is due to "Adhoc Queries" The rest rest of the usage shows up under the actual DB ...
4
votes
1answer
477 views
Two relationships to same table
i have one transaction table, each transaction has 5-6 contacts involved. each contact has the same fields like name, address, cell, email etc.
So the best thing I guess is to use the same contact ...
0
votes
1answer
1k views
SQL keyword difference between MySQL and Oracle 10g?
Good afternoon,
Are there differences between Oracle 10g and MySQL with the CREATE, ALTER, DROP, REF, PRIMARY KEY, FOREGIN KEY and attribute variable type keywords?
The reason I ask, is I'm planning ...
3
votes
4answers
614 views
How can I generate an Entity-Relationship diagram and SQL DDL from natural language text?
Good morning,
Using LaTeX or another text-macro tool/library, how can I use natural language text to describe relationships, then generate an Entity-Relationship Diagram and generate SQL DDL to ...
4
votes
3answers
806 views
Is the ADO.NET Entity Framework known for generating poorly performing queries?
This question is inspired by the comment posted to the latest ServerFault blog post:
Are you guys still using LINQ to SQL?
I know I can use SQL Server Profiler and/or the ToTraceString method to ...
5
votes
3answers
2k views
Why does this Entity Framework query perform so bad in MySQL?
Let me give you a little setup. We have a InnoDB table on MySQL 5.1 with close to 20 million records, no foreign keys, and proper indexes for queries we do. We are using the latest 6.3.5 MySQL ...
