当前位置: 首页>>代码示例>>C#>>正文


C# Mapping.TableJoin方法代码示例

本文整理汇总了C#中Mapping.TableJoin方法的典型用法代码示例。如果您正苦于以下问题:C# Mapping.TableJoin方法的具体用法?C# Mapping.TableJoin怎么用?C# Mapping.TableJoin使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Mapping的用法示例。


在下文中一共展示了Mapping.TableJoin方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: GenerateToObject_WhenCalledWithMultipeTablesUsingTableJoinIsJoinedCorrectly_SetsPropertiesCorrectly

        public void GenerateToObject_WhenCalledWithMultipeTablesUsingTableJoinIsJoinedCorrectly_SetsPropertiesCorrectly()
        {
            IMapping mapping = new Mapping();
            Func<TestClass, TestContent, bool> canJoin = ( x, y ) => x.TestContentId == y.Id;
            Action<TestClass, List<TestContent>> listSet = ( x, y ) => x.TestContents = y;

            mapping.Table<TestClass>( 0 );
            mapping.Table<TestContent>( 1 );

            mapping.TableJoin( canJoin, listSet );

            var classMapResult = new ClassMapResult
            {
                Mappings = (Mapping)mapping
            };

            var mockDataReader = new MockDataReader();
            var table = mockDataReader.AddTable( "Length2", "TestContentId" );
            var contentTable = mockDataReader.AddTable( "Id", "Name" );

            mockDataReader.AddRow( table, 1, 1 );

            mockDataReader.AddRow( contentTable, 1, "Name1" );
            mockDataReader.AddRow( contentTable, 2, "Name2" );

            var func = MappingGenerator.Generate<TestClass>( new MockDataReader(), classMapResult );

            var result = func( mockDataReader, new Dictionary<MappingEnum, object>
            {
                {
                    MappingEnum.TableJoin, new List<TableJoinMap>
                    {
                        new TableJoinMap
                        {
                            CanJoin = canJoin,
                            ListSet = listSet
                        }
                    }
                }
            }, new Dictionary<Tuple<int, Type>, Func<IDataRecord, Dictionary<MappingEnum, object>, object>>() );

            Assert.AreEqual( 1, result.TestContents.Count );
            Assert.AreEqual( "Name1", result.TestContents[ 0 ].Name );
        }
开发者ID:jrote1,项目名称:SqlObjectHydrator,代码行数:44,代码来源:MappingGeneratorTests.cs

示例2: GenerateToObject_WhenCalledWithVariableTableType_UsesCorrectType

        public void GenerateToObject_WhenCalledWithVariableTableType_UsesCorrectType()
        {
            IMapping mapping = new Mapping();

            Func<Result, BaseScore, bool> canJoin = ( r, b ) => r.Id == b.ResultId;
            Action<Result, List<BaseScore>> listSet = ( r, b ) => r.Scores = b;
            Func<IDataRecord, Type> variableTableType = dataRecord =>
            {
                switch ( dataRecord.GetInt32( 4 ) )
                {
                    case 1:
                        return typeof( IntScore );
                    default:
                        return typeof( StringScore );
                }
            };

            mapping.TableJoin<Result, BaseScore>( canJoin, listSet );
            mapping.VariableTableType<BaseScore>( variableTableType );

            mapping.Table<Result>( 0 );
            mapping.Table<BaseScore>( 1 );

            var classMapResult = new ClassMapResult
            {
                Mappings = (Mapping)mapping
            };

            var mockDataReader = new MockDataReader();

            var results = mockDataReader.AddTable( "Id", "Name" );
            var scores = mockDataReader.AddTable( "Id", "ResultId", "Value", "ValueString", "ResultType" );

            mockDataReader.AddRow( results, 1, "Result 1" );
            mockDataReader.AddRow( results, 2, "Result 2" );

            mockDataReader.AddRow( scores, 1, 1, 10, "", 1 );
            mockDataReader.AddRow( scores, 1, 2, DBNull.Value, "10", 2 );

            var func = MappingGenerator.Generate<List<Result>>( new MockDataReader(), classMapResult );

            var dictionary = new Dictionary<Tuple<int, Type>, Func<IDataRecord, Dictionary<MappingEnum, object>, object>>();

            var result = func( mockDataReader, new Dictionary<MappingEnum, object>
            {
                {
                    MappingEnum.TableJoin, new List<TableJoinMap>
                    {
                        new TableJoinMap
                        {
                            CanJoin = canJoin,
                            ListSet = listSet
                        }
                    }
                },
                {
                    MappingEnum.VariableTableType, new Dictionary<Type, object>
                    {
                        { typeof( BaseScore ), variableTableType }
                    }
                }
            }, dictionary );

            Assert.AreEqual( 1, result[ 0 ].Id );
            Assert.AreEqual( 2, result[ 1 ].Id );

            Assert.AreEqual( 1, result[ 0 ].Scores.Count );
            Assert.AreEqual( 1, result[ 1 ].Scores.Count );

            Assert.IsInstanceOf<IntScore>( result[ 0 ].Scores[ 0 ] );
            Assert.IsInstanceOf<StringScore>( result[ 1 ].Scores[ 0 ] );

            Assert.AreEqual( 10, ( result[ 0 ].Scores[ 0 ] as IntScore ).Value );
            Assert.AreEqual( "10", ( result[ 1 ].Scores[ 0 ] as StringScore ).ValueString );
        }
开发者ID:jrote1,项目名称:SqlObjectHydrator,代码行数:75,代码来源:MappingGeneratorTests.cs


注:本文中的Mapping.TableJoin方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。