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