Guidance for SQL server connection using C#

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hello Experts,
I need your valuable Suggetions/guidance about sql server connection.

Actually i am creating online test application in c# windows forms and there will be maximum of 200 pcs and in every pc i will install this application.
my connection string for every pc is same:

C#

Data Source = xxxxxxx; Initial Catalog = xxx; Integrated Security = False; User ID = 123; Password = 123@123

I open connection at login time and dispose it when application exit(never close in between them)

For backup purpose:
When user start test, i save student answer for the selected questions into database if user select an option. on other hand application update test time left in every seconds to database again.

My question is:
will there be any problem(deadlock/blocking/any other) occured if 200 pc using same connection string to open connection?

What I have tried:

I am not sure about if problem will occured or not.

Posted 14-Dec-16 20:23pm

KManishS

Updated 14-Dec-16 20:57pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-12-14T20:57:00

Depends on the SQL configuration - there is an option to restrict the max simultaneous connections: Configure the user connections Server Configuration Option[^]
But, the max you can have is theoretically 32,767 so 200 shouldn't be a problem, provided the hardware and bandwidth is up to it. In practice, you won't have nearly as many as 200 connections busy at the same time - you can't coordinate the PC's to talk at the exact same time anyway, because Windows is a preemptive multitasking OS, so you have no control over what threads are running across the machine at any specific time.