Beispiel #1
0
        private static List <TEntity> MapQueryToEntities(NpgsqlDataReader reader)
        {
            var result = new List <TEntity>();

            List <TableColumn> columns = MetadataResolver.TableColumns <TEntity>();
            Dictionary <string, TableColumn> columnMap = columns.ToDictionary(i => i.Name, i => i);

            while (reader.Read())
            {
                var entity = new TEntity();

                for (int i = 0; i < reader.FieldCount; i++)
                {
                    string columnName = reader.GetName(i);

                    if (columnMap.TryGetValue(columnName, out TableColumn column))
                    {
                        object columnValue = reader.GetValue(i);
                        column.SetValue(entity, columnValue);
                    }
                    else
                    {
                        Console.ForegroundColor = ConsoleColor.Yellow;
                        Console.WriteLine($"Warning: Failed to map db column '{columnName}' a TableColumn on entity '{typeof(TEntity)}' (did the schema change recently? is a db upgrade required?)");
                        Console.ResetColor();
                    }
                }

                result.Add(entity);
            }

            return(result);
        }
Beispiel #2
0
        private List <string> GetColumnDefinitions()
        {
            List <string> definitions = MetadataResolver.TableColumns <TEntity>()
                                        .Select(c => c.DefinitionForCreateTable())
                                        .ToList();

            List <string> compositeKeys = MetadataResolver.CompositePrimaryKeys <TEntity>();

            if (!compositeKeys.IsNullOrEmpty())
            {
                definitions.Add(
                    $"PRIMARY KEY({string.Join(", ", compositeKeys)})");
            }

            return(definitions);
        }
Beispiel #3
0
        public InsertCommand(
            Func <NpgsqlConnection> getConnection,
            List <TEntity> entities)
        {
            _getConnection = getConnection ?? throw new ArgumentNullException(nameof(getConnection));

            if (entities.IsNullOrEmpty())
            {
                throw new ArgumentNullException(nameof(entities), "At least one entity must be provided for an Insert command.");
            }

            List <TableColumn> columns = MetadataResolver.TableColumns <TEntity>();

            AppendInsertInto(columns);
            AppendEntityValues(entities, columns);
        }