static void Main(string[] args)
{
//Log Instance
Logger Log = new Logger();
Log.WriteEntry("Iniciando o SQL BUILDER", EventLogEntryType.Information);
//DataSet Instance
PersonsTableAdapter dsPersons = new PersonsTableAdapter();
#region DataBase Test
//Getting DataTable
PersonsDataTable dt = null;
dsPersons.Fill(dt);
//Generate the insert command from an excel file.
SqlBuilder.BuildInsertCommand(dt);
FileManager.WriteText(SqlBuilder.GeneratedSQL.ToString(), AppSettings.SCRIPT_PATH);
#endregion
#region Excel Test
DataTable dataTable = null;
//Reading Excel and Generate a DataTable
dataTable = ExcelReader.ReadRows();
//Setting a name to the Data Table.
dt.TableName = "dbo.Persons";
#endregion
Console.WriteLine("Scripts e Log gerados com sucesso. Aperte uma tecla para finalizar.");
Console.ReadLine();
}
public override global::System.Data.DataTable Clone()
{
PersonsDataTable cln = ((PersonsDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
private void InitClass()
{
this.DataSetName = "PersonsDs";
this.Prefix = "";
this.Namespace = "http://tempuri.org/PersonsDs.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tablePersons = new PersonsDataTable();
base.Tables.Add(this.tablePersons);
}
internal void InitVars(bool initTable)
{
this.tablePersons = ((PersonsDataTable)(base.Tables["Persons"]));
if ((initTable == true))
{
if ((this.tablePersons != null))
{
this.tablePersons.InitVars();
}
}
}
internal PersonsRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tablePersons = ((PersonsDataTable)(this.Table));
}
internal PersonsRow(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tablePersons = ((PersonsDataTable)(this.Table));
}
private void InitClass() {
this.DataSetName = "PersonsDs";
this.Prefix = "";
this.Namespace = "http://tempuri.org/PersonsDs.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tablePersons = new PersonsDataTable();
base.Tables.Add(this.tablePersons);
}
internal void InitVars(bool initTable) {
this.tablePersons = ((PersonsDataTable)(base.Tables["Persons"]));
if ((initTable == true)) {
if ((this.tablePersons != null)) {
this.tablePersons.InitVars();
}
}
}
