Hey Everyone,

I'm playing around with an Umbraco 7.1.1 site on Azure ( as a Web Site ) but I'm having trouble retrieving data from a custom table in my Azure SQL database. When I do so I get the error "Keyword not supported: 'flush interval'", could this be a compatibility issue with Azure SQL?

edit: here is a snippet of my code:

ConnectionStringSettings cs = ConfigurationManager.ConnectionStrings["umbracoDbDSN"];
using(SqlConnection con = new SqlConnection(cs.ToString()))
{
    string sql = "SELECT * FROM [dbo].[MyTable]";
    con.Open();
    using(SqlCommand cmd = new SqlCommand(sql,con))
    {
        SqlDataReader reader = cmd.ExecuteReader(); 
    }
    con.Close();
}