how would i be able to learn about client server architecture with c#

Question

there is a database on a server computer and the client front end applications are connecting this server and the database . how will the database know which client is connecting the database , time of connection ....in  c#

 please provide overview of client server architecture and the examples