connection timeout using edmx RRS feed

  • Question

  • Hi,

    We are facing time out isssue for long running SP's whihc are called using EDMX. when we run SP's from query analyzer results getting displyed withing 50 seconds , however in EDMX we are getting folllowing exception after 20 seconds

    Message = "Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."

    connection string in config file is like follows

    <add name="ENTITY" connectionString="*****.ssdl|res://*/ENTITY.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=<SQLAZURE>.windows.net;Initial Catalog=DBNAME; Connection Timeout=120 ;User ID=USERID;Password=PWS;MultipleActiveResultSets=False&quot;" providerName="System.Data.EntityClient" />

    How to overcome this issue ?

    Tuesday, July 5, 2011 3:37 PM


All replies