Esempio n. 1
0
        public void Scan_with_casting_Enum_to_integer()
        {
            var entitySet = workspace.GetEntityContainer("MessageContainer", DataSpace.CSpace).GetEntitySetByName("MessageSet", false);

            var query = entitySet.Scan()
                        .Where(
                c =>
                c.Property("Id").Equal(
                    c.Property("MessageType").CastTo(
                        TypeUsage.CreateDefaultTypeUsage(workspace.GetPrimitiveTypes(DataSpace.CSpace).Single(t => t.Name == "Int32")))));

            var expectedSql =
                "SELECT [Extent1].[Id] AS [Id], [Extent1].[MessageType] AS [MessageType] FROM [dbo].[Message] AS [Extent1] WHERE [Extent1].[Id] =  CAST( [Extent1].[MessageType] AS int)";

            QueryTestHelpers.VerifyQuery(query, workspace, expectedSql);
        }