The EntitySpaces Community

Share and learn about the EntitySpaces Architecture.
Welcome to The EntitySpaces Community Sign in | Join | Help
in
Home Forums Photos

ES ignores commandTimeout setting for the connection

Last post 03-18-2008, 2:40 PM by leonidbogdanov. 3 replies.
Sort Posts: Previous Next
  •  03-17-2008, 3:05 PM 8439

    ES ignores commandTimeout setting for the connection

    Below is my config file. I don't do anything with connections inside my code. When I check entity.es.Connection.CommandTimeout in the debugger, it is set to null instead of 300

    -Leonid

    Code:
      <EntitySpaces>
        <connectionInfo default="SQL">
          <connections>
            <add name="SQL"
              providerMetadataKey="esDefault"
              sqlAccessType="DynamicSQL"
              provider="EntitySpaces.SqlClientProvider"
              providerClass="DataProvider"
              commandTimeout="300"
              connectionString="Application Name=Test;server=.;database=Test;user id=test;password="
              databaseVersion="2005"
            />
          </connections>
        </connectionInfo>
      </EntitySpaces>
    
     

     

  •  03-17-2008, 6:18 PM 8442 in reply to 8439

    Re: ES ignores commandTimeout setting for the connection

    All of our methods in the providers do this:

    if(request.CommandTimeout != null)
    {
        cmd.CommandTimeout = request.CommandTimeout.Value;
    }


    What method are you calling, Load, Save, Query ?  I will ensure it works for ES2008 but it should work now.



    EntitySpaces | Twitter | BLOG | Please honor our Software License
  •  03-17-2008, 6:33 PM 8443 in reply to 8439

    Re: ES ignores commandTimeout setting for the connection

    Here are our current tests for ES2007, which are all passing.

    Code:
    // Collection
    aggTestColl = new AggregateTestCollection();
    Assert.AreEqual(999, aggTestColl.es.Connection.CommandTimeout);
    Assert.IsTrue(aggTestColl.Query.Load(), "Query.Load");
    aggTestColl = new AggregateTestCollection();
    Assert.AreEqual(999, aggTestColl.es.Connection.CommandTimeout);
    Assert.IsTrue(aggTestColl.LoadAll(), "LoadAll");
    
    // Entity
    aggTest = new AggregateTest();
    Assert.AreEqual(999, aggTest.es.Connection.CommandTimeout);
    aggTest.Query.es.Top = 1;
    Assert.IsTrue(aggTest.Query.Load(), "Query.Load");
    int aggKey = aggTest.Id.Value;
    aggTest = new AggregateTest();
    Assert.AreEqual(999, aggTest.es.Connection.CommandTimeout);
    Assert.IsTrue(aggTest.LoadByPrimaryKey(aggKey), "LoadByPK");

    David Neal Parsons
    www.entityspaces.net
  •  03-18-2008, 2:40 PM 8457 in reply to 8443

    Re: ES ignores commandTimeout setting for the connection

    I'm sorry. It's working now. I probably made a change to the wrong config file, or something else stupid.

    I apologize for waisting your time on this.

    Leonid.

View as RSS news feed in XML