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);
}
