C# (CSharp) StatementIfTempTableExists Examples

Example #1

File: TSqlStatementBuilder.cs Project: tralivali1234/SqExpress

        public override void VisitIfTempTableExists(StatementIfTempTableExists statementIfTempTableExists)
        {
            var tableName = TSqlExporter.Default.ToSql(statementIfTempTableExists.Table);

            tableName = "tempdb.." + tableName;

            var condition = SqQueryBuilder.IsNotNull(new ExprScalarFunction(null,
                                                                            new ExprFunctionName(true, "OBJECT_ID"),
                                                                            new[] { SqQueryBuilder.Literal(tableName) }));

            new StatementIf(condition, statementIfTempTableExists.Statements, statementIfTempTableExists.ElseStatements).Accept(this);
        }

Example #2

File: PgSqlStatementBuilder.cs Project: tralivali1234/SqExpress

 public override void VisitIfTempTableExists(StatementIfTempTableExists statementIfTempTableExists)
 {
     throw new NotSupportedException("Not supported");
 }

Example #3

File: SqlStatementBuilderBase.cs Project: tralivali1234/SqExpress

 public abstract void VisitIfTempTableExists(StatementIfTempTableExists statementIfTempTableExists);