public void TableNameForGitHubIssue17ShouldPass()
{
var sql = @"SELECT [Extent1].[Id] AS [Id], [Extent1].[Identifier] AS [Identifier], [Extent1].[Name] AS [Name], [Extent1].[Latitude] AS [Latitude], [Extent1].[Longitude] AS [Longitude], [Extent1].[FIR] AS [FIR], [Extent1].[UIR] AS [UIR], [Extent1].[ICAO] AS [ICAO], [Extent1].[MagneticVariation] AS [MagneticVariation], [Extent1].[Frequency] AS [Frequency], [Extent1].[CountryName] AS [CountryName], [Extent1].[CountryId] AS [CountryId], [Extent1].[StateId] AS [StateId], [Extent1].[CityId] AS [CityId], [Extent1].[IsActive] AS [IsActive] FROM [dbo].[Points] AS [Extent1] WHERE ([Extent1].[IsActive] = @DynamicFilterParam_000001) OR (@DynamicFilterParam_000002 IS NOT NULL)";
var tableName = new MappingsExtractor().ParseTableName(sql);
Assert.AreEqual("Points", tableName.Name);
Assert.AreEqual("dbo", tableName.Schema);
}
public void SkipViewsInMappingExtractor()
{
using (var ctx = new UnitTestContext())
{
var extractor = new MappingsExtractor(ctx);
var hasMappings = extractor.HasMappings(typeof(Contact));
Assert.IsFalse(hasMappings);
}
}
public void ReportTableNames()
{
using (var ctx = new UnitTestContext())
{
var extractor = new MappingsExtractor();
var tableName = extractor.GetTableName(ctx, typeof(Period));
Assert.AreEqual("Some.Complex_Schema Name", tableName.Schema);
Assert.AreEqual("Period", tableName.Name);
tableName = extractor.GetTableName(ctx, typeof(SummaryReportFROMTableASExtent));
Assert.AreEqual(nameof(SummaryReportFROMTableASExtent), tableName.Name);
tableName = extractor.GetTableName(ctx, typeof(DetailReportWithFROM));
Assert.AreEqual("In # Some.Complex_Schema @Name", tableName.Schema);
Assert.AreEqual("SELECT WORSE FROM NAMES AS Extent1", tableName.Name);
}
}
public void SchoolTableNames()
{
using (var ctx = new UnitTestContext())
{
var extractor = new MappingsExtractor();
var tableName = extractor.GetTableName(ctx, typeof(Course));
Assert.AreEqual("dbo", tableName.Schema);
Assert.AreEqual("Course", tableName.Name);
tableName = extractor.GetTableName(ctx, typeof(Department));
Assert.AreEqual("dbo", tableName.Schema);
Assert.AreEqual("Department", tableName.Name);
tableName = extractor.GetTableName(ctx, typeof(Instructor));
Assert.AreEqual("dbo", tableName.Schema);
Assert.AreEqual("Instructor", tableName.Name);
tableName = extractor.GetTableName(ctx, typeof(OfficeAssignment));
Assert.AreEqual("dbo", tableName.Schema);
Assert.AreEqual("OfficeAssignment", tableName.Name);
}
}
