private void CreateFakeTableDefinition(ObjectIdentifier table) { var fakeTable = new ExecuteStatement(); fakeTable.ExecuteSpecification = new ExecuteSpecification(); var procedureReference = new ProcedureReference(); procedureReference.Name = new SchemaObjectName(); procedureReference.Name.Identifiers.Add("tSQLt".ToIdentifier()); procedureReference.Name.Identifiers.Add("FakeTable".ToIdentifier()); var entity = new ExecutableProcedureReference(); entity.ProcedureReference = new ProcedureReferenceName(); entity.ProcedureReference.ProcedureReference = procedureReference; entity.Parameters.Add( ParametersHelper.CreateStoredProcedureParameter(string.Format("{0}", table.GetSchema()))); entity.Parameters.Add( ParametersHelper.CreateStoredProcedureParameter(string.Format("{0}", table.GetName()))); fakeTable.ExecuteSpecification.ExecutableEntity = entity; _testProcedure.StatementList.Statements.Add(fakeTable); }
public static SchemaObjectName ToSchemaObjectName(this ObjectIdentifier source) { var target = new SchemaObjectName(); target.Identifiers.Add(source.GetSchema().ToScriptDomIdentifier().Quote()); target.Identifiers.Add(source.GetName().ToScriptDomIdentifier().Quote()); return(target); }
public static bool EqualsName(this ObjectIdentifier source, SchemaObjectName target) { if (target.SchemaIdentifier == null) { return(Quote.Name(source.GetName()) == Quote.Name(target.BaseIdentifier.Value)); } return(Quote.Name(source.GetSchema()) == Quote.Name(target.SchemaIdentifier.Value) && Quote.Name(source.GetName()) == Quote.Name(target.BaseIdentifier.Value)); }
public static string GetSchemaObjectName(this ObjectIdentifier name) { return(string.Format("{0}.{1}", name.GetSchema(), name.GetName())); }