90301 / dynamicquery Goto Github PK

http://csharp-station.com/Tutorial/AdoDotNet/Lesson02

This should help with setting up a connection to a SQL database.

Option 1:

private const string NAME_CONST = "name";
public static ColVariable NameColVariable = new ColVariable(NAME_CONST, qmd);
...
jt1.addSameColJoin(NAME_CONST);

Option 2:

public static ColVariable NameColVariable = new ColVariable(NAME_CONST, qmd);
...
jt1.addSameColJoin(NAME_CONST);

Personally I'm leaning more towards constant generation as it might be easier to maintain the code if you don't have to change the text in multiple places.

Default behavior for joins (Code Generation Version) should look for column names that are the same. Better behavior would be to look for key relationships.

List out columns of SQL Query in C# Code Generator.
Similar process can be used for a col choose (For optimized queries)

Have the ability to cache results (This is an opt in feature for a given collection / object)

Some Cache Strategies:

• Refresh if after X minutes (only refreshes when data is needed)
• Refresh on Method Call Only (Essentially allows a refresh button to be added, or custom user implementation)
• Others?

Method that gets the efficient table with joins only occurring where it is relevant. Similar to getFullTable() method.

NOTE: I think this can only use LEFT JOINS. If any other type of join is used with the potential of data loss, it must throw an error and/or call getFullTable()

select cols with blacklisted and replacement words.

Generate and read an XML file for program configuration.

If the user so desires for certain object, they can specify the columns that they want to use, and the code generator will only produce those fields, saving memory.

☑ Select columns to generate (saves memory)

☑ Column
☐ Column
☑ Column

I'm trying to set this static delegate method that will be called every time a "SELECT" Statement is fired off. It seems to be giving me an error, so I suppose I have the syntax wrong or something.

Inspired By:
https://stackoverflow.com/questions/7367152/dynamically-assign-method-method-as-variable

Look into Case Statement support for "Special" Columns.

Also, Test performance of SQL vs C#.

http://www.wpftutorial.net/DataGrid.html

One way to handle collection loading would be to pass the collection to a method

MyCollection = qmd.loadToCollection(MyCollection);

Select * with a count of 1
Intended to get all column names.
Intended to be used by C# Code Generation and SQL auto-complete / builders.