what are those methods of sqlexpress responsible for making a bridge ?

Accepted answer

Yes.

That's the reason I said the 'default' way to communicate.

The application do not want to take efforts of change the way of communication if you change connection string from local db to the remove one.

Hope it clarifies.

+1

Arijeet Ghosh4y ago

does java commuicates sql server using tcp or client server technique...? if they bothreside in the same pc then does it uses tcp...?

+1

Nitin Sontakke4y ago

That's precisely what I have said.

There is no MAY BE in it.

By default SQL server works on tcp protocol.

+1

Arijeet Ghosh4y ago

maybe using ports or client server methodology is used by microsoft or java to communicate with these database

+1

Nitin Sontakke4y ago

Is this an interview question, please?

Not too sure what would be an answer.

However, I may say that it could be tcp protocol.

Because Microsoft SQL Server default tcp port is 1433 and it is through this that any and all applications can send requests and receive response from.

The ADO.NET a wrapper written in .NET framework does exactly the same and hides all low level calls and keeps us developers abstracted from it.

Hope it helps!

+1