Cannot insert to database through console app

Question

I am trying to write an insert method in a C# console application. I have set a breakpoint and it does hit ExecuteNonQuery, however, after stepping through it just hangs there and control does not seem to return back to the application. When I perform a read action on the database it works perfectly.

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    SqlCommand command = new SqlCommand("INSERT INTO dbo.dbDevices (ipAddress) VALUES (@value)", connection);
    command.Parameters.Add("@value", "SUCCESS");
    command.ExecuteNonQuery();
}

I have also checked the active connections to the database and it says that it is awaiting command.

.Net SqlClient Data Provider     5720       AWAITING COMMAND

More information can be provided if needed.

Have you compared the working and non-working queries with SQL Profiler? — Michael Liu, Jul 12 '15 at 03:21
Do you have a transaction scope around this block? ... and what number is returned by `command.ExecuteNonQuery()` — Matthew Whited, Oct 11 '16 at 15:39

score 1 · Answer 1 · answered Jul 12 '15 at 02:05

1

Not sure if it's related but you're passing parameter value using deprecated method. I recommend using AddWithValue method. So it's either:

command.Parameters.AddWithValue("@value", "SUCCESS");

or

command.Parameters.Add(new SqlParameter("@value", "SUCCESS"));

answered Jul 12 '15 at 02:05

msmolcic

6,407
8
32
56

I realised this and have changed it, thanks for the advice though : ) – Johnathon64 Jul 12 '15 at 02:21
@Johnathon64 Did it solve your problem or you're still getting the same error? – msmolcic Jul 12 '15 at 02:22
I'm not actually getting any errors, it just hangs there – Johnathon64 Jul 12 '15 at 02:34
@Johnathon64 You could be getting timeouts if your table is locked for some reason or if your transaction log is full. – msmolcic Jul 12 '15 at 02:49
I just did a DBCC OPENTRAN on SSMS and it said no active open transactions – Johnathon64 Jul 12 '15 at 02:55

Cannot insert to database through console app

1 Answers1