CatFactory.SqlServer
CatFactory.SqlServer copied to clipboard
hherzl
SqlServer package for CatFactory
Change Signature for Extensions in Entity Helper in order to reduce syntax. ```csharp var student = db .DefineEntity(new { Id = 0, GivenName = "", MiddleName = "", FamilyName =...
Add `QueryBuilder` definition in `Features` namespace. This definition must allow to define a query and there will be extension methods for common queries: Select All ```csharp var query = QueryBuilder...
Add `FnListExtendedPropertyResult` class as result of `fn_listextendedproperty` invoke, the class must contain the following properties: ```csharp public class FnListExtendedPropertyResult { public string ObjType { get; set; } public string ObjName...
Add `GetConnection` extension method for `DatabaseImportSettings`.
Add the following overload `AddOrUpdateExtendedPropertyAsync (database, Tokens.MS_DESCRIPTION, request.FixedDescription)` as extension method for `SqlConnection` instances in order to allow edit description for database.
Add the following extension methods to retrieve Database type map: 1. `GetByDatabaseType(this IEnumerable sequence, string databaseType)` 1. `GettByClrType(this IEnumerable sequence, Type type)`
Review constructors in `DatabaseImportSettings`, also add a new method to create a new instance with name as parameter.
Refactory `ExtendedPropertyRepository`, make async all methods
Add a new class with name `SqlServerToken`, this class will contain the following tokens: 1. schema 2. table 3. view 4. column
`SqlServerDatabaseFactory` doesn't import extended properties.