The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
532 views

SSIS Package Execution From Visual Studio Unit Test

Hello I am attempting to run a test which contains the following code: string pkgLocation; Package pkg; Application app; DTSExecResult pkgResults; ...
0
votes
1answer
19 views

Foreign key not able to get one to many working

I want to have a one to many relation with player points but I need it in such a way that entity framework sees it as a collection so i can add to it. I mean that one player can have multiple points ...
3
votes
0answers
24 views

Azure SQL DB migration from Visual Studio raises collation error

I want to run a migration in my Azure hosted database. The migration works perfect in several local machines. When I try targeting the Azure database it raises the following exception: Column X is ...
2
votes
0answers
599 views

Rolling Back Stored Procedures in Entity Framework

I currently working a on project that operates within a transaction in entity framework. Before now all of the changes were made using a DataContext. I need to add a call to a stored procedure using ...
2
votes
0answers
2k views

SQL Server intermittent error 40 Could not open a connection to SQL Server or The network path was not found

I am getting intermittent errors as per the below stack trace. I am using C# Entity Framework with SQL Server 2012 enterprise running on a separate server computer. I can connect and query the DB ...
1
vote
0answers
59 views

Splitting very large working table

I read the good posts here and here, but my scenario is a bit different, I cannot consider that older data becomes read-only data because any record in my Transactions table can be subject to updates ...
1
vote
0answers
497 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 ...
0
votes
0answers
20 views

Entity Framework using filestream

Does Entity Framework support file I/O using Win32 / .net API's? From online it states that Entity Framework only supports filestream using T-SQL which again can bloat the buffer pool and cause ...
0
votes
0answers
21 views

SQL architecture question. User entity in 2 tables

I use Symfony 2 framework and standardized bundles to operate entities. So I have somewhat stable User Entity, which is based on the bundle structure. It contains mainly service information like ...
0
votes
0answers
48 views

Multiple M-M relationships between tables

I am working on the design of a new database. In this database, we track equipment corrective actions (repair). We have three personnel fields in each Equipment Corrective Action record: initiated ...
0
votes
0answers
196 views

Are these One-to-Zero-or-One relationship correct?

I'm working with SQL Server 2012 and I have these three tables: CREATE TABLE [dbo].[CODES] ( [CODE] [nvarchar](20) NOT NULL, [ ... ] , CONSTRAINT [PK_CODES] PRIMARY KEY CLUSTERED ( ...
0
votes
0answers
70 views

Is there a standard direction to read cardinality relationships in?

I'm reading some documentation, and before getting egg on my face for questioning it, I'd like to check the standard way of reading UML cardinality relationships. The docs I have look like the image ...
0
votes
0answers
21 views

Identification of other entities.

Given the following scenario, what three other entities (and their attributes) would be of importance to this model? SCENARIO: The transport authority in Jamaica has recently added train ...
0
votes
0answers
203 views

SQL Server and Entity Framework

We are currently experiencing a problem with Entity Framework which generates a sp_executesql statement. This statement is below. The statement runs fine in SQL Server however through the front end ...