22 lines
811 B
C#
22 lines
811 B
C#
#r "Strata.SqlUtilities/bin/Debug/net8.0/Strata.SqlUtilities.dll"
|
|
#r "Strata.SqlUtilities.SqlServer/bin/Debug/net8.0/Strata.SqlUtilities.SqlServer.dll"
|
|
|
|
using Strata.SqlUtilities.Breakdowns.SqlServer;
|
|
using Strata.SqlUtilities.Expressions;
|
|
|
|
var query = new QueryBreakdown();
|
|
var col = new GenericColumnExpression("Name", "Users");
|
|
var expr = col == "John";
|
|
|
|
query.AddWhereExpression(expr);
|
|
|
|
Console.WriteLine($"WhereClause.Clause: '{query.WhereClause.Clause}'");
|
|
Console.WriteLine($"Length: {query.WhereClause.Clause.Length}");
|
|
Console.WriteLine($"Contains 'John': {query.WhereClause.Clause.Contains("'John'")}");
|
|
|
|
// Print each character
|
|
for (int i = 0; i < query.WhereClause.Clause.Length; i++)
|
|
{
|
|
Console.WriteLine($"[{i}]: '{query.WhereClause.Clause[i]}' (0x{((int)query.WhereClause.Clause[i]):X2})");
|
|
}
|