command-timeout Questions

1

I am finding that neither the DatabaseFacade.SetCommandTimeout method nor the SqlServerDbContextOptionsBuilder.CommandTimeout method are having any effect on my code and instead a long running SQL ...
Hardshell asked 23/4, 2021 at 2:47

10

Solved

I am looking a way to set CommandTimeout for DbContext. After searching I found the way by casting DbContext into ObjectContext and setting value for CommandTimeout property of objectContext. var ...
Emmyemmye asked 11/5, 2012 at 10:26

3

Solved

I have recently started using LinqPad, and bought the Autocomplete option and am really loving it. This is an excellent product! I wanted to ask if there is a way for me to control the command tim...
Krilov asked 9/12, 2011 at 16:47

5

I have just a general type of question. If I have a C# application that calls a SQL Server stored procedure, and the C# application times out, does the procedure call on the server continue running...
Cia asked 21/4, 2016 at 14:42

1

Solved

I want to set command timeout for query execution, currently I am doing context.Database.CommandTimeout = 90; but i feel this is not working, I tried checking the process logs in database but found...

3

Solved

I cannot find the a way to set the command timeout of a linq query using entity framework 4.3 and its' DbContext. How do I increase Commandtimeout in entity framework? EDIT I am actually looking ...
Interlining asked 31/7, 2012 at 19:16

1

Is anyone aware of a way to set the UnderlyingCriteria when using Session.Query? I'm trying to set a more restrictive command timeout (or query timeout) for one specific query and I am trying to a...
Perak asked 2/1, 2014 at 19:32

1

Solved

The default CommandTimeout value is 30 seconds. You can manually change the value on an instance of the command object by doing the following Dim cmd As New System.Data.SqlClient.SqlCommand cmd.Co...
Rewrite asked 6/8, 2013 at 20:26

2

I am successfully using Powershell with SMO to backup most databases. However, I have several large databases in which I receive a "timeout" error "System.Data.SqlClient.SqlException: Timeout expir...
Totten asked 6/5, 2010 at 20:29

1

Solved

Sql Server is accessible. I want to migrate database using Entity Framework migrations. There i have "Images" table with 130k records having images. In migration there "INDEX" added to these table ...

3

Solved

I am using Microsoft.SqlServer.Management.Smo. My Code: Server server = new Server(new ServerConnection( new SqlConnection(ConnectionString)); server.ConnectionContext.ExecuteNonQuery(script); ...
Tirza asked 9/5, 2012 at 7:53

5

Solved

How do I decide what length of time to use as a timeout when using an SqlCommand object? On parts of the code I'm working on (written by somebody else) I have: cmd.CommandTimeout = 60; Which I ...
Canotas asked 11/8, 2011 at 9:38

2

How do I increase the timeout in NHibernate Linq To Sql? Not the Connection Timeout but the ado command timeout. using (ISession session = NHibernateHelper.OpenSession(NHibernateHelper.Databases...

2

Solved

I have a datareader source firing some sql which takes longer than 30 seconds to run, so it's timing out. I can not find a command timeout property on the datareader source component, or the data f...
Savoy asked 10/11, 2009 at 21:11
1

© 2022 - 2024 — McMap. All rights reserved.