C# (CSharp) SqlConnectionExtensions.GetSelectIntoTemporaryTableCommand примеры использования

Пример #1

Файл: SqlConnectionExtensionsTests.cs Проект: leonard-thieu/toofz-data

            public void ReturnsSelectIntoTemporaryTableCommand()
            {
                // Arrange
                var connection    = new SqlConnection();
                var baseTableName = "myTableName";
                var tempTableName = "#myTableName";

                // Act
                var comnand = SqlConnectionExtensions.GetSelectIntoTemporaryTableCommand(connection, baseTableName, tempTableName);

                // Assert
                Assert.Equal(@"SELECT TOP 0 *
INTO [#myTableName]
FROM [myTableName];", comnand.CommandText, ignoreLineEndingDifferences: true);
            }