private void UpdateTable(Type type)
        {
            IEnumerable <TableSchemaInformation> columns = TableColumns(type);
            var types = PostgreScriptGenerator.StaticDataMapper().Keys.ToList();

            var props = type.GetProperties().Where(v => types.Contains(v.PropertyType)).ToList();

            FindDifferenceColums(type, columns, props);
        }
        public void FindDifferenceColums(Type type, IEnumerable <TableSchemaInformation> dbColumns, IEnumerable <PropertyInfo> entityProps)
        {
            StringBuilder addBuilder    = new StringBuilder();
            StringBuilder removeBuilder = new StringBuilder();
            var           dbColumsList  = dbColumns as TableSchemaInformation[] ?? dbColumns.ToArray();

            var dbColumnNames = dbColumsList.Select(v => v.column_name).ToList();
            var dbColumnTypes = dbColumsList.Select(v => v.data_type).ToList();
            var propertyInfos = entityProps as PropertyInfo[] ?? entityProps.ToArray();
            var removeProps   = dbColumnNames.Except(propertyInfos.Select(v => v.Name)).ToList();
            var addProps      = propertyInfos.Select(v => v.Name).Except(dbColumnNames).ToList();

            foreach (var dbColumn in dbColumsList)
            {
                var entityProp = propertyInfos.FirstOrDefault(v => v.Name == dbColumn.column_name);
                if (entityProp == null)
                {
                    continue;
                }
                DbColumnType propType = PostgreScriptGenerator.DataTypeMapper()[entityProp.PropertyType];
                if (propType.Type == dbColumn.data_type && propType.IsNullable == IsNullableConverter(dbColumn.is_nullable))
                {
                    continue;
                }
                removeProps.Add(dbColumn.column_name);
                addProps.Add(entityProp.Name);
            }
            foreach (var propString in addProps)
            {
                var    prop   = entityProps.FirstOrDefault(v => v.Name == propString);
                string script = "ALTER TABLE \"" + type.Name + "\" ADD COLUMN IF NOT EXISTS \"" + propString + "\" " + PostgreScriptGenerator.StaticDataMapper()[prop.PropertyType];

                if (!DataHelper.IsNullableType(prop.PropertyType))
                {
                    script += GenerateDefaultValue(type, prop);
                }

                script += ";";
                addBuilder.AppendLine(script);
            }
            foreach (var propString in removeProps)
            {
                string script = "ALTER TABLE \"" + type.Name + "\" DROP COLUMN \"" + propString + "\";";
                removeBuilder.AppendLine(script);
            }

            _connection.Execute(removeBuilder.ToString() + addBuilder);
        }