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
– Michael Liu, Commented Jul 12, 2015 at 3:21
Do you have a transaction scope around this block? ... and what number is returned by command.ExecuteNonQuery() — Matthew Whited
– Matthew Whited, Commented Oct 11, 2016 at 15:39

msmolcic · Accepted Answer · 2015-07-12 02:05:19Z

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, 2015 at 2:05

msmolcic

6,5968 gold badges39 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Johnathon64 Over a year ago

I realised this and have changed it, thanks for the advice though : )

msmolcic Over a year ago

@Johnathon64 Did it solve your problem or you're still getting the same error?

Johnathon64 Over a year ago

I'm not actually getting any errors, it just hangs there

msmolcic Over a year ago

@Johnathon64 You could be getting timeouts if your table is locked for some reason or if your transaction log is full.

Johnathon64 Over a year ago

I just did a DBCC OPENTRAN on SSMS and it said no active open transactions

Collectives™ on Stack Overflow

Cannot insert to database through console app

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related