J
Jim Light
Hi,
I'm in the process of creating a light-weight object abstraction layer
(not an ORM) over ADO.NET, to encapsulate the most commonly used SQL
queries (as an exercise). Classes are as follows: Sum.cs, Insert.cs,
Count.cs,... etc.
While these classes don't create a direct object mapping to a given db
structure, they do allow me to stay in the C# domain without having to
drift off in the T-SQL domain.
I realized that there must be certain basic SQL commands that when
compounded, yield all other SQL queries that would usually be coded in
T-SQL. Although these compounded commands might not execute as
efficiently as T-SQL statements, they would make programming db backed
apps much easier.
My Question: Does anybody have a complete list of these basic SQL
building blocks out of which all other more complex statemtents could
be created (without having to resort to T-SQL)?
Thank you.
Regards,
Jim Light
I'm in the process of creating a light-weight object abstraction layer
(not an ORM) over ADO.NET, to encapsulate the most commonly used SQL
queries (as an exercise). Classes are as follows: Sum.cs, Insert.cs,
Count.cs,... etc.
While these classes don't create a direct object mapping to a given db
structure, they do allow me to stay in the C# domain without having to
drift off in the T-SQL domain.
I realized that there must be certain basic SQL commands that when
compounded, yield all other SQL queries that would usually be coded in
T-SQL. Although these compounded commands might not execute as
efficiently as T-SQL statements, they would make programming db backed
apps much easier.
My Question: Does anybody have a complete list of these basic SQL
building blocks out of which all other more complex statemtents could
be created (without having to resort to T-SQL)?
Thank you.
Regards,
Jim Light