/// <summary> /// Get the parameters from columns names without the primary key. /// </summary> /// <param name="tableName"></param> /// <param name="dbName"></param> /// <returns></returns> public string GetParametersWithoutDataTypes(string tableName, string dbName) { var connectionStr = ConfigurationManager.ConnectionStrings["default"].ConnectionString; if (string.IsNullOrEmpty(connectionStr)) { connectionStr = "data source=(local); user Id=sa; password=P@ssw0rd;"; } var columnsGetter = new TableColumnsGetter(connectionStr, tableName, dbName); var tableColumnsList = columnsGetter.GetTableColumns().ToList(); //var tableColumns = columnsGetter.GetTableColumnsNames(); string insertParameters = string.Empty; var columnsCount = tableColumnsList.Count(); for (int index = 0; index <= columnsCount - 1; index++) { insertParameters += "@" + tableColumnsList[index].ColumnName; if (index < columnsCount - 1) { insertParameters += ", "; } } return(insertParameters); }
/// <summary> /// Gets the insert parameters from columns names and data types. /// </summary> /// <param name="tableName"></param> /// <param name="dbName"></param> /// <returns></returns> public string GetParameters(string tableName, string dbName) { var connectionStr = ConfigurationManager.ConnectionStrings["default"].ConnectionString; if (string.IsNullOrEmpty(connectionStr)) { connectionStr = "data source=(local); user Id=sa; password=P@ssw0rd;"; } var columnsGetter = new TableColumnsGetter(connectionStr, tableName, dbName); var tableColumnsList = columnsGetter.GetTableColumns().ToList(); // var tableColumns = columnsGetter.GetTableColumnsNames(); var primaryKeyName = PrimaryKeyGetter.GetTablePrimaryKeyName(tableName, dbName); string insertParameters = string.Empty; var columnsCount = tableColumnsList.Count(); for (int index = 0; index <= columnsCount - 1; index++) { if (tableColumnsList[index].ColumnName.ToLower() != primaryKeyName.ToLower()) { insertParameters += "@" + tableColumnsList[index].ColumnName + " " + tableColumnsList[index].ColumnType.ToString(); var columnLimit = !string.IsNullOrEmpty(tableColumnsList[index].ColumnLimit) ? "(" + tableColumnsList[index].ColumnLimit + ")" : string.Empty; insertParameters += " " + columnLimit; if (index < columnsCount - 1) { insertParameters += " ,"; } } } return(insertParameters); }