static void Main(string[] args)
{
while (true)
{
Console.WriteLine("Enter expression:" + Environment.NewLine);
string input = input = Console.ReadLine();
if (input == "exit")
{
break;
}
if (SQE.IsValidSyntax(input))
{
var mssqlQueryGenerator = new MSSQLGenerator();
var sqlCommand = SQE.GenerateCommand(mssqlQueryGenerator, input);
using (var connection = new SqlConnection(@""))
{
connection.Open();
sqlCommand.Connection = connection;
sqlCommand.Prepare();
var reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
Console.WriteLine($"RowID: {reader[0]}");
}
}
}
}
}
public void MSSQLGen_CrossApplyProperties(string query)
{
var sqlCommand = SQE.GenerateCommand(new MSSQLGenerator("slg.lgs"), query);
Assert.IsNotNull(sqlCommand);
Assert.IsTrue(sqlCommand.CommandText.StartsWith("SELECT * FROM slg.lgs CROSS APPLY (SELECT CAST(Properties AS XML)) AS X(X) WHERE"));
}
public void MSSQLGen_NoCustomProperties(string query)
{
var sqlCommand = SQE.GenerateCommand(new MSSQLGenerator("slg.lgs"), query);
Assert.IsNotNull(sqlCommand);
Assert.IsTrue(sqlCommand.CommandText.StartsWith("SELECT * FROM slg.lgs WHERE"));
}
public void MSSQLGen_Empty_Only_Spaces()
{
var sqlCommand = SQE.GenerateCommand(new MSSQLGenerator("slg.lgs"), " ");
Assert.IsNotNull(sqlCommand);
Assert.AreEqual("SELECT * FROM slg.lgs", sqlCommand.CommandText);
}
