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)); }