What type connection is the fastest in C# to SQL Server

[Richard]

Can someone give me some insight in what type
of connection is the fastest to connect to SQL Server.

Thx in Advance

 

[Marc Gravell]

In which way? If you mean topology, then a local SQL Server will
obviously be a lot quicker than a LAN or WAN server... and talking "TDS"
will be a lot quicker than using http services (which I really don't
recommend anyway). But SqlConnection will worry about this for you.

In terms of "connect" speed - then a pooled connection will have less
initial latency than a non-pooled connection - but again, SqlConnection
will worry about this for you.

In terms of data-access, well - that is a large topic... "read less
data" and "use suitable indexes" being the short version.

Did you have something specific in mind?

Marc

 

[Richard]

Thx for your answer and to give me a bit more insight.

I am going to read a bit more about pooled connections en how

SqlConnection controls it for me.

It obvious that a lot of the speed depends on data access and

correct indexes, thx for the reminder

Basicly my colleage asked me to check the difference between connections

like an connectionstring or ado.net connection. He was a little vage about

it's for a simpel program that do uses a lot of data all the time, that's
way

Thx again

 

[Ignacio Machin ( .NET/ C# MVP )]

Basicly my colleage asked me to check the difference between connections

like an connectionstring or ado.net connection. He was a little vage about

Now you lost me, ConnectionString is a property of the ADO.NET
Connection object.

Just use it , and if you find any problem then you worry yourself