public void ValidateCreateQueryDefinition() { string query = "select * from s where s.Account = @account"; string paramName = "@account"; string paramValue = "12345"; QueryDefinition sqlQueryDefinition = new QueryDefinition(query) .UseParameter(paramName, paramValue); SqlQuerySpec sqlQuerySpec = sqlQueryDefinition.ToSqlQuerySpec(); Assert.AreEqual(query, sqlQuerySpec.QueryText); Assert.AreEqual(1, sqlQuerySpec.Parameters.Count); SqlParameter sqlParameter = sqlQuerySpec.Parameters.First(); Assert.AreEqual(paramName, sqlParameter.Name); Assert.AreEqual(paramValue, sqlParameter.Value); string newParamValue = "9001"; sqlQueryDefinition.UseParameter(paramName, newParamValue); sqlQuerySpec = sqlQueryDefinition.ToSqlQuerySpec(); Assert.AreEqual(query, sqlQuerySpec.QueryText); Assert.AreEqual(1, sqlQuerySpec.Parameters.Count); sqlParameter = sqlQuerySpec.Parameters.First(); Assert.AreEqual(paramName, sqlParameter.Name); Assert.AreEqual(newParamValue, sqlParameter.Value); }
public void ThrowOnNullConnectionString() { QueryDefinition sqlQueryDefinition = new QueryDefinition("select * from s where s.Account = 1234"); sqlQueryDefinition.UseParameter(null, null); }