All Questions
8,447
questions with no upvoted or accepted answers
17
votes
3
answers
3k
views
Azure SQL stored procedure ridiculously slow called from C#
Summary:
We have two identical databases, one on a local server, one on Azure.
We have a C# system that accesses these databases, calling stored procedures.
The stored procedures are running very, ...
- 732
9
votes
1
answer
7k
views
OData in WebAPI without something like Entity Framework
I'm building a WebAPI that is getting its data from legacy systems so no Entity Framework available for me. Now I want to use OData functionality but is not going to work if I have somethink like ...
9
votes
3
answers
3k
views
Problem with Insert query to Paradox table using C#
I have Paradox 5.x tables I need to connect to in order to select and update.
I am using OLEDBConnection.
selecting from the tables I have no problem.
while trying to insert into the tables I met a ...
- 651
8
votes
1
answer
2k
views
Entity Framework not respecting Command Timeout
I ran into an issue with my entity framework based api where 3rd party developers were mistakenly sending queries that were way too large and caused the system to drop performance. I've informed them ...
- 496
8
votes
0
answers
2k
views
Extracting Files from Sharepoint 2013 WSS_Content Database
Sharepoint 2013 stores documents in the WSS_Content database in a table called DocStreams.
Up until Sharepoint 2010, files where stored in a single row in a VarBinary column. Since Sharepoint 2013, ...
- 1,736
8
votes
3
answers
12k
views
SQL Error "uncommittable transaction is detected at the end of batch" without transactions on db
I'm facing the following problem at different points of my code.
An SqlException is returned from DB (SQL Server) with message "Uncommitable Transaction is detected at the end of the batch. ...
- 89
7
votes
0
answers
268
views
oData V4 - returning unsorted data causing duplicate records
I have an oData model and am having trouble with default ordering on paged collections.
When I retrieve people from my database using 'odata/people', without any ordering in the query itself, the ...
- 71
7
votes
1
answer
981
views
TransactionScope breaking SqlConnection pooling?
I have an odd situation with TransactionScope and async/synchronous SQL calls that I'm having difficulty understanding. I hope that someone with a deeper understanding of the ins and outs of these ...
7
votes
1
answer
1k
views
Entity Framework .NET Core 2.0 Query hangs on execution when subquery is executed
With a regular version of EF 6.x I was able to do subqueries pretty easy with the following query:
var q = from u in db.User
let actions = from ua in db.UserActions
...
- 11.7k
6
votes
3
answers
2k
views
Entity Framework change Id type
I've changed type of Id property from Int to Guid, no other entities reference that Id and I've manually deleted all records of that entity from database, my generated migration class looks like this:
...
- 2,734
6
votes
1
answer
1k
views
Error Inserting Cast data and null fields C#
I'm working on Visual Studio 2012 using an MS Access file as Database and having a bunch of trouble with this insert:
cmd.Parameters.Add(new OleDbParameter("@codigo", cal.CodEtiq)); // Value = int
...
- 199
6
votes
1
answer
807
views
Assign multiple tables to single class in linq table mapping
I may be asking the question wrongly as I'm getting to grips with Linq. I have searched for a solution and the only thing I have come up with is the possibility that inheritance is the answer, but I ...
- 553
5
votes
1
answer
1k
views
Data Table to Livecharts
I am using Live charts library in my Application to generate a Line graph. The way it works is like this;
SeriesCollection = new SeriesCollection
{
new LineSeries
{
Title = "Series 1",...
- 165
5
votes
1
answer
87
views
c# Combobox displays System.Data.Datarowview because of point
this is code which give an error
DataSet Music = new DataSet();
Music= DBI.musicall();
comboBox1.DisplayMember= "music1.name"; // with .
comboBox1.ValueMember="Id";
...
- 226
5
votes
0
answers
1k
views
Azure Management API - TokenCredentials vs TokenCloudCredentials
Here's the latest version of the Compute prerelease that leverages the new resource group way of controlling access:
https://www.nuget.org/packages/Microsoft.Azure.Management.Compute/13.0.4-prerelease
...
- 828