public void Initialize() { FulcrumApplicationHelper.UnitTestSetup(nameof(ManyToOneTest)); var connectionString = TestSettings.ConnectionString; FulcrumAssert.IsNotNullOrWhiteSpace(connectionString); var manyTableMetadata = new SqlTableMetadata { TableName = "TestItem", CustomColumnNames = new[] { "Value", "IncreasingNumber", "NumberModulo", "DecreasingString", "ParentId" }, OrderBy = new string[] { } }; var oneTableMetadata = new SqlTableMetadata { TableName = "TestItem", CustomColumnNames = new[] { "Value" }, OrderBy = new string[] { } }; _oneStorage = new CrudSql <TestItemId <Guid> >(new DatabaseOptions { ConnectionString = connectionString }, oneTableMetadata); _manyStorage = new ManyToOneSql <TestItemManyToOneCreate <Guid, Guid?>, TestItemManyToOne <Guid, Guid?>, TestItemId <Guid> >( new DatabaseOptions { ConnectionString = connectionString }, manyTableMetadata, "ParentId", _oneStorage); }
public void Inititalize() { FulcrumApplicationHelper.UnitTestSetup(nameof(CrudTestValidated)); var connectionString = ConfigurationManager.AppSettings["ConnectionString"]; var tableMetadata = new SqlTableMetadata { TableName = "TestItem", CustomColumnNames = new[] { "Value" }, OrderBy = new string[] { } }; _storage = new CrudSql <TestItemBare, TestItemValidated <Guid> >(connectionString, tableMetadata); }
/// <summary> /// Constructor /// </summary> public SqlServerStorage(string connectionString) { // Person var tableMetadata = new SqlTableMetadata { TableName = "Person", CustomColumnNames = new [] { "Name" }, OrderBy = new [] { "Name" }, EtagColumnName = "Etag", }; var person = new CrudSql <PersonTable>(connectionString, tableMetadata); Person = person; // Consent tableMetadata = new SqlTableMetadata { TableName = "Consent", CustomColumnNames = new[] { "Name" }, OrderBy = new[] { "Name" }, EtagColumnName = "Etag", }; var consent = new CrudSql <ConsentTable>(connectionString, tableMetadata); Consent = consent; // Address tableMetadata = new SqlTableMetadata { TableName = "Address", CustomColumnNames = new[] { "Type", "Street", "City", "PersonId" }, OrderBy = new[] { "Type" }, EtagColumnName = "Etag", ForeignKeyColumnName = "PersonId" }; Address = new ManyToOneSql <AddressTable, PersonTable>(connectionString, tableMetadata, "PersonId", person); // PersonConsent tableMetadata = new SqlTableMetadata { TableName = "PersonConsent", CustomColumnNames = new[] { "HasGivenConsent", "PersonId", "ConsentId" }, OrderBy = new string[] { }, EtagColumnName = "Etag", ForeignKeyColumnName = "PersonId" }; PersonConsent = new ManyToManySql <PersonConsentTable, PersonTable, ConsentTable>(connectionString, tableMetadata, "PersonId", person, "ConsentId", consent); }
public void Initialize() { FulcrumApplicationHelper.UnitTestSetup(nameof(CrudTestValidated)); var connectionString = TestSettings.ConnectionString; FulcrumAssert.IsNotNullOrWhiteSpace(connectionString); var tableMetadata = new SqlTableMetadata { TableName = "TestItem", CustomColumnNames = new[] { "Value" }, OrderBy = new string[] { } }; _storage = new CrudSql <TestItemBare, TestItemValidated <Guid> >(new DatabaseOptions { ConnectionString = connectionString }, tableMetadata); }
public void Inititalize() { var connectionString = ConfigurationManager.AppSettings["ConnectionString"]; var manyTableMetadata = new SqlTableMetadata { TableName = "TestItem", CustomColumnNames = new[] { "Value", "ParentId" }, OrderBy = new string[] { } }; var oneTableMetadata = new SqlTableMetadata { TableName = "TestItem", CustomColumnNames = new[] { "Value" }, OrderBy = new string[] { } }; _oneStorage = new CrudSql <TestItemId <Guid> >(connectionString, oneTableMetadata); _manyStorage = new ManyToOneSql <TestItemManyToOneCreate <Guid?>, TestItemManyToOne <Guid, Guid?>, TestItemId <Guid> >(connectionString, manyTableMetadata, "ParentId", _oneStorage); }
public void Initialize() { FulcrumApplicationHelper.UnitTestSetup(nameof(CrudTestId)); var connectionString = TestSettings.ConnectionString; FulcrumAssert.IsNotNullOrWhiteSpace(connectionString); var tableMetadata = new SqlTableMetadata { TableName = "TestItem", CustomColumnNames = new[] { "Value" }, OrderBy = new string[] { } }; var options = new DatabaseOptions { ConnectionString = connectionString, DefaultLockTimeSpan = TimeSpan.FromSeconds(30) }; options.DistributedLockTable = new DistributedLockTable(options); _storage = new CrudSql<TestItemBare, TestItemId<Guid>>(options, tableMetadata); }
public async Task Initialize() { FulcrumApplicationHelper.UnitTestSetup(nameof(CrdTestSearch)); var connectionString = TestSettings.ConnectionString; FulcrumAssert.IsNotNullOrWhiteSpace(connectionString); var tableMetadata = new SqlTableMetadata { TableName = "TestItem", CustomColumnNames = new[] { "Value", "IncreasingNumber", "NumberModulo", "DecreasingString" }, OrderBy = new string[] {} }; _storage = new CrudSql <TestItemSort <Guid>, TestItemSort <Guid> >(new DatabaseOptions { ConnectionString = connectionString }, tableMetadata); await _storage.DeleteAllAsync(); }