public void SelectFunctionColumnsFromOneTable()
{
SqlBuilder builder = SqlBuilder.Select(20).From("Account", null).AllColumns(false)
.Fn()
.GetDate("Today")
.Concat("My Name",
ConstantField <string> .Constant("Michael"),
ConstantField <string> .Constant(" "),
ConstantField <string> .Constant("Randrup")
)
.ToTable()
.Column <string>(Guid.NewGuid().ToString(), "UniqueID")
.Builder;
Console.WriteLine(builder.ToSql());
Guid g = StopWatch.Start();
ResultTable result = builder.Execute(120);
Console.WriteLine("ResulTable with {0} rows executed in {1}s", result.Count, StopWatch.Stop(g, StopWatch.WatchTypes.Seconds));
g = StopWatch.Start();
List <Account> list = builder.List <Account>(null, 30, true, true);
Console.WriteLine("List<Account> with {0} rows executed in {1}s", list.Count, StopWatch.Stop(g, StopWatch.WatchTypes.Seconds));
list = null;
result = null;
}
public static void RunChunkedCheckersScenario(string outputFile = "C:\\Users\\Justin Murray\\Desktop\\chunks.png")
{
ConstantField <float> half = new ConstantField <float>(10, 10, 0.5f);
ConstantField <float> one = new ConstantField <float>(10, 10, 1f);
ChunkField <float> chunks = new ChunkField <float>(100, 100);
for (int y = 0; y < chunks.Height; y += half.Height)
{
for (int x = 0; x < chunks.Width; x += half.Width)
{
chunks.TryAddChunk(x, y, (x + y) / 10 % 2 == 0 ? half : one);
}
}
Utils.OutputField(chunks, new Bitmap(chunks.Width, chunks.Height), outputFile);
}
