If you can add the request to in-memory .net queue it should solve your problem. Keep a thread which will monitor and trigger job from the queue. This way you can decide on a number of threads which can run parallelly (one or multiple).

Ashwin Shetty

if you need to read data (forward only), you can write code like

$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "id: " . $row["id"];
}
} else {
echo "0 results";
}
$conn->close();

you can look at the sample available here

Ashwin Shetty

I can see your for-loop influencing $user object

for($i=0;$irowResult);$i++){
echo $user['id'];
}

Ashwin Shetty

Check your web.config if you have any setting in it. Also .net 2 and 4 should be running in two different pool else only one which starts first will get started.

Ashwin Shetty

Check the application pool in IIS, it will be pointing toward .net 2 framework pool. If you already have application pool with .net 4 framework associate it else you have to create a pool for .net 4 and then associate it.

Ashwin Shetty

You can do it by using Events. Place the dll or class on which you have your Contract is implemented in same application domain. Class / Dll should have public event with args which need to transfer to your service to process. Bind the event in the service which shall let your service know about the request. We have used same method to communicate with window service. let me know if you need further help, you can mail me at ashwin.shetty@eclerx.com.

ashwin shetty

if you r using SQL please check the below code string strSqlConnectionstring = "sqlserver details with provider"; System.Data.SqlClient.SqlConnection _ObjSQLCon = new System.Data.SqlClient.SqlConnection(strSqlConnectionstring.ToString()); System.Data.SqlClient.SqlCommand _ObjSqlCom = new System.Data.SqlClient.SqlCommand(); try { _ObjSQLCon.Open(); _ObjSqlCom.Connection = _ObjSQLCon; // your store procedure name _ObjSqlCom.CommandText = "Your Store procedure name"; _ObjSqlCom.CommandType = System.Data.CommandType.StoredProcedure; // you can add parameter as per your requirement // parameter name & datatype should be as per you have mentioned in your procedure // set the direction of your parameter // you need to add output parameter in the same way but direction out be output _ObjSqlCom.Parameters.Add("your parameter name", System.Data.SqlDbType.Char, 50).Direction = System.Data.ParameterDirection.Input; _ObjSqlCom.Parameters.Add("your output parameter name", System.Data.SqlDbType.Char, 50).Direction = System.Data.ParameterDirection.Output; _ObjSqlCom.Parameters[0].Value = "your parameter value"; _ObjSqlCom.ExecuteNonQuery(); // to get the output value you can use either array location of that parameter or the parameter name // if you are confused then just right click on _ObjSqlCom and view it in immediate window after you have executed _ObjSqlCom.ExecuteNonQuery(); } catch { } finally { strSqlConnectionstring = string.Empty; if (_ObjSqlCom != null) { _ObjSqlCom.Dispose(); _ObjSqlCom = null; } if (_ObjSQLCon != null) { if (_ObjSQLCon.State != System.Data.ConnectionState.Closed) { _ObjSQLCon.Close(); } _ObjSQLCon.Dispose(); _ObjSQLCon = null; } } if you further douts feel free to email me at ashwin@omtechsolutions.com :)

Ashwin Shetty. Mumbai. India