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); }