SQL - Create table from existing DataTable/Dataset data with ADO.net?
I need to create two tables.
The first one I can get via database with a command. No sweat.
The second one is built from the first one with nested SELECT statements, JOINs, and operators like SUM, AVG etc. So it needs more functionality than filtering and sorting. It is done in C# with .NET 2.0, so no advanced features available.
Essentially I can execute a second command, but I wonder if I can circumvent this if I have all my necessary data already available in a DataTable/Dataset ?
I am aware that I can create and fill a new table manually, but that would be tedious and error-prone.
I do need both tables and the database must not be influenced. The solution must use only ADO.NET, there is no SQL Server or other tools installed.
Is there any way to create a new table with SQL-Like statements on the already local existing data and if yes, what are the limitations ?