public ClientAuth GetClientDetails(int clientId) { ClientAuth clientObj = new ClientAuth(); StringBuilder sb = new StringBuilder("SELECT CL.*,CLAU.* FROM CLIENT CL JOIN CLIENTAUTHENTICATION CLAU ON CL.CLIENTID=CLAU.CLIENTID WHERE CL.CLIENTID = @ClientId"); if (ClientDA.GetClientDetails(clientId, sb.ToString(), clientObj)) { return(clientObj); } else { return(null); } }