Database

UPDATE table_name SET column_name=value

UPDATE table_name SET column_name=column_name+1

wjbjnr wrote:

I just wanted to know how many different connections at a same time can be made
from different computers?

Mehdi Ghiasi wrote:

Whether it creates performance problems?

I are Troll

Mehdi Ghiasi wrote:

So, isn't there any performance problem?

I are Troll

Mehdi Ghiasi wrote:

almost 10 connections

[ServiceBehavior(IncludeExceptionDetailInFaults = true,
                    InstanceContextMode = InstanceContextMode.Single,
                    ConcurrencyMode = ConcurrencyMode.Single)]
[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
public class DataService : SingletonDataServiceBase<String>, ISingletonDataServiceBase<String>
{
    protected override String OnFunctionRequest(string function)
    {
        try
        {
            OracleConnection oracleCon = new OracleConnection(ConfigurationManager.ConnectionStrings["CNRPConnectionString"].ConnectionString);
            OracleCommand sqlCom = new OracleCommand(
               string.Format( "begin   :REF_CUR := {0} ;end;", function), oracleCon);

            sqlCom.Parameters.Add("REF_CUR", OracleDbType.RefCursor, ParameterDirection.ReturnValue);

            OracleDataAdapter dataAdapter = new OracleDataAdapter();
            sqlCom.Connection.Open();
            sqlCom.ExecuteNonQuery();

            //Populate the DataSet and close the connection
            DataSet dataSet = new DataSet();
            dataAdapter.Fill(dataSet, "REF_CUR", (OracleRefCursor)(sqlCom.Parameters["REF_CUR"].Value));

            // Release rare resources immediately to prevent memory leaks and database locks
            sqlCom.Dispose();
            oracleCon.Close();
            oracleCon.Dispose();

            return this.Serialize(dataSet.Tables[0]);
        }
        catch (Exception Exp)
        {
            throw Exp;
        }
    }

CNRP_S_15_108_STRUCINF_I(7,null,'PWS Repository','Storage',0,null,null,null,null,0,null,null,null,null,null,-1,0,1995,0,0,null,null,0,-1,'16-May-11',-1,'13-Apr-11')