/// <summary>
        ///
        /// </summary>
        /// <typeparam name="TModel"></typeparam>
        /// <typeparam name="TProperty"></typeparam>
        /// <param name="result"></param>
        /// <param name="selector"></param>
        /// <param name="name"></param>
        /// <param name="value"></param>
        /// <returns></returns>
        public static EntityResult <TModel> AddExtendedProperty <TModel, TProperty>(this EntityResult <TModel> result, Expression <Func <TModel, TProperty> > selector, string name, string value) where TModel : class
        {
            result.Table[GetPropertyName(selector)].ExtendedProperties.Add(new ExtendedProperty
            {
                Name  = name,
                Value = value
            });

            return(result);
        }
        /// <summary>
        ///
        /// </summary>
        /// <typeparam name="TModel"></typeparam>
        /// <param name="result"></param>
        /// <param name="name"></param>
        /// <param name="value"></param>
        /// <returns></returns>
        public static EntityResult <TModel> AddExtendedProperty <TModel>(this EntityResult <TModel> result, string name, string value) where TModel : class
        {
            result.Table.ExtendedProperties.Add(new ExtendedProperty
            {
                Name  = name,
                Value = value
            });

            return(result);
        }
        public static EntityResult <TModel> AddUnique <TModel, TProperty>(this EntityResult <TModel> result, Expression <Func <TModel, TProperty> > selector, string constraintName = null) where TModel : class
        {
            var names = GetPropertyNames(selector).ToList();

            result.Table.Uniques.Add(new Unique
            {
                ConstraintName = constraintName ?? result.Database.NamingConvention.GetUniqueConstraintName(result.Table, names.ToArray()),
                Key            = names
            });

            return(result);
        }
        // todo: Fix the definition for check contraint in Core module

        //public static EntityResult<TModel> AddCheck<TModel, TProperty>(this EntityResult<TModel> result, Expression<Func<TModel, TProperty>> selector, string value, string constraintName = null) where TModel : class
        //{
        //    var names = GetPropertyNames(selector).ToList();

        //    result.Table.Checks.Add(new Check
        //    {
        //        ConstraintName = constraintName ?? result.Database.NamingConvention.GetUniqueConstraintName(result.Table, names.ToArray()),
        //        Key = names
        //    });

        //    return result;
        //}

        public static EntityResult <TModel> AddDefault <TModel, TProperty>(this EntityResult <TModel> result, Expression <Func <TModel, TProperty> > selector, string value, string constraintName = null) where TModel : class
        {
            var names = GetPropertyNames(selector).ToList();

            result.Table.Defaults.Add(new Default
            {
                ConstraintName = constraintName ?? result.Database.NamingConvention.GetDefaultConstraintName(result.Table, names.First()),
                Value          = value
            });

            return(result);
        }
        /// <summary>
        ///
        /// </summary>
        /// <typeparam name="TModel"></typeparam>
        /// <typeparam name="TProperty"></typeparam>
        /// <param name="result"></param>
        /// <param name="selector"></param>
        /// <param name="constraintName"></param>
        /// <returns></returns>
        public static EntityResult <TModel> SetPrimaryKey <TModel, TProperty>(this EntityResult <TModel> result, Expression <Func <TModel, TProperty> > selector, string constraintName = null) where TModel : class
        {
            var names = GetPropertyNames(selector).ToList();

            result.Table.PrimaryKey = new PrimaryKey
            {
                ConstraintName = result.Database.NamingConvention.GetPrimaryKeyConstraintName(result.Table, names.ToArray()),
                Key            = names
            };

            return(result);
        }
        /// <summary>
        ///
        /// </summary>
        /// <typeparam name="TModel"></typeparam>
        /// <typeparam name="TProperty"></typeparam>
        /// <param name="result"></param>
        /// <param name="selector"></param>
        /// <param name="table"></param>
        /// <param name="constraintName"></param>
        /// <returns></returns>
        public static EntityResult <TModel> AddForeignKey <TModel, TProperty>(this EntityResult <TModel> result, Expression <Func <TModel, TProperty> > selector, Table table, string constraintName = null) where TModel : class
        {
            var names = GetPropertyNames(selector).ToList();

            result.Table.ForeignKeys.Add(new ForeignKey
            {
                ConstraintName = string.IsNullOrEmpty(constraintName) ? result.Database.NamingConvention.GetForeignKeyConstraintName(result.Table, names.ToArray(), table) : constraintName,
                Key            = GetPropertyNames(selector).ToList(),
                References     = table.FullName
            });

            return(result);
        }
#pragma warning disable CS1591
        public static EntityResult <TModel> DefineEntity <TModel>(this SqlServerDatabase database, TModel model) where TModel : class
        {
            var result = new EntityResult <TModel>
            {
                Table = new Table
                {
                    Schema = database.DefaultSchema,
                    Name   = model.GetType().Name
                },
                Database = database,
                Model    = model
            };

            result.Table.ImportBag.ExtendedProperties = new Collection <ExtendedProperty>();

            foreach (var property in model.GetType().GetProperties())
            {
                var propType = property.PropertyType;

                var defType = database.DefaultTypeMaps.FirstOrDefault(item => item.Type == propType);

                var type = string.Empty;

                if (defType == null)
                {
                    var types = database.GetDatabaseTypeMaps(propType).ToList();

                    type = types.Count == 0 ? "" : types.First().DatabaseType;
                }
                else
                {
                    type = defType.DatabaseType;
                }

                result.Table.Columns.Add(new Column
                {
                    Name = property.Name,
                    Type = type
                });

                result.Table.Columns.Last().ImportBag.ExtendedProperties = new Collection <ExtendedProperty>();
            }

            database.Tables.Add(result.Table);

            return(result);
        }
        public static EntityResult <TModel> SetColumnFor <TModel>(this EntityResult <TModel> result, Expression <Func <TModel, TimeSpan?> > selector, bool nullable = false) where TModel : class
        {
            var column = new Column
            {
                Name = GetPropertyName(selector)
            };

            if (result.Table.Columns.Contains(column))
            {
                result.Table[column.Name].Nullable = nullable;
            }
            else
            {
                result.Table.Columns.Add(column);
            }

            return(result);
        }
        public static EntityResult <TModel> SetColumnFor <TModel>(this EntityResult <TModel> result, Expression <Func <TModel, short?> > selector, string type = "", bool nullable = false) where TModel : class
        {
            var column = new Column
            {
                Name = GetPropertyName(selector)
            };

            if (result.Table.Columns.Contains(column))
            {
                if (!string.IsNullOrEmpty(type))
                {
                    result.Table[column.Name].Type = type;
                }

                result.Table[column.Name].Nullable = nullable;
            }
            else
            {
                result.Table.Columns.Add(column);
            }

            return(result);
        }
Esempio n. 10
0
        public static EntityResult <TModel> AddExtendedProperty <TModel>(this EntityResult <TModel> result, string name, string value) where TModel : class
        {
            result.Table.ImportBag.ExtendedProperties.Add(new ExtendedProperty(name, value));

            return(result);
        }
Esempio n. 11
0
        public static EntityResult <TModel> SetIdentity <TModel>(this EntityResult <TModel> result, Expression <Func <TModel, short?> > selector, int seed = 1, int increment = 1) where TModel : class
        {
            result.Table.Identity = new Identity(GetPropertyName(selector), seed, increment);

            return(result);
        }