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

Arijeet Ghosh

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
You can simply build console app to test.

Console app sample:
namespace DatabaseConnectionTester
{
    using System;
    using System.Data.Common;
    using System.Data.SqlClient;

    internal static class Program
    {
        private static int Main(string[] args)
        {
            bool result;

            if (args.Length == 0)
            {
                result = true;
            }
            else
            {
                try
                {
                    var connectionString =
                        "Connect Timeout=10;Pooling=false;Integrated Security=sspi;server=" + args[0];

                    using (var connection = new SqlConnection(connectionString))
                    {
                        connection.Open();
                        result = true;
                    }
                }
                catch (DbException)
                {
                    result = false;
                }

                if (args.Length > 1)
                {
                    Console.WriteLine(result);
                }
            }

            return Convert.ToInt32(result);
        }
    }
}
+1
Rijwan Ansari5y ago
You can provide connection string into configuration and check connection based on application. Also you can set time-out in connection string.
Connection test function.
//connection string sample: Server=.;Initial Catalog=;Persist Security Info=False;User ID=userName;Password=YourPassword;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=true;Connection Timeout=300000;
public bool TryOpenConnection(string connectionString)
    {
        try {
            var conn =new SqlConnection(connectionString);
            conn.Open();
            connection = conn;
            return true;
        }
        catch (exception) {
            connection = null;
            return false;
        }
    }
+1
Sachin Singh5y ago
each database has a connection property we call it connection string , which includes server name , database name and username and password (Authentication details if any otherwise windows authentication) , we specify the connection string in the application.
so each application having the same connectionstring will point to same database.
+1
Amit Gupta5y ago
I haven't tested but if you are talking about sql db then try like below https://stackoverflow.com/a/56219967
+1