Dotnetnuke module creator (DMC) creates sql stored procedures for all data operations:
1.Getting data collection from selected tables.
2.Getting one particular record by primary key.
3.Saving (Insert/Update) one record (list/save/delete/get).
Generates two types of sql files:
1.Files with stored procedures that can be run immediately on server.
2.SqlDataProvider files that can be used for installation packages.