title: connecting to Azure database
body: <p>I have an Umbraco site developed using SQL CE, I then changed this to SQLEXPRESS and can connect to both locally. I deployed to Azure (initially using CE) and all worked OK, I then created a SQL Azure database and copied the SQLEXPRESS to there, again this seems to have worked and I can connect to the SQL Azure database using SQL Management Studio. </p>
  
  <p>The problem occurs when I try to connect to the Azure db from my application, I have updated the web.config using the Azure connection string but both locally and in Azure I get -</p>
  
  <pre><code>Value cannot be null.
  Parameter name: sqlSyntax 
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
  
   Exception Details: System.ArgumentNullException: Value cannot be null.
  Parameter name: sqlSyntax
  
  Source Error: 
  
  
   An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  
  
  Stack Trace: 
  
  
  
  [ArgumentNullException: Value cannot be null.
  Parameter name: sqlSyntax]
     Umbraco.Core.Persistence.Repositories.PetaPocoRepositoryBase`2..ctor(IDatabaseUnitOfWork work, CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntax) +120
     Umbraco.Core.Persistence.Repositories.DomainRepository..ctor(IDatabaseUnitOfWork work, CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntax) +23
     Umbraco.Core.Services.DomainService.GetAll(Boolean includeWildcards) +75
     Umbraco.Web.Routing.PublishedContentRequestEngine.FindDomain() +286
     Umbraco.Web.Routing.PublishedContentRequestEngine.PrepareRequest() +15
     Umbraco.Web.UmbracoModule.ProcessRequest(HttpContextBase httpContext) +361
     Umbraco.Web.UmbracoModule.&lt;Init&gt;b__8(Object sender, EventArgs e) +80
     System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +141
     System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously) +69
  </code></pre>
  
  <p>Any ideas what is going wrong?</p>