public Table(Schema schema, String name, Boolean isView) : base() { this.Schema = schema; this.Name = IdentifierHelper.GetStrippedSqlIdentifier(name); this.IsView = isView; }
public Table(Schema schema, String name, TableType tableType) : base() { this.Schema = schema; this.Name = IdentifierHelper.GetStrippedSqlIdentifier(name); this.TableType = tableType; }
public Schema(Database database, String name, Boolean isDefaultSchema) : base() { this.Database = database; this.Name = IdentifierHelper.GetStrippedSqlIdentifier(name); this.IsDefaultSchema = isDefaultSchema; this.StoredProcedures = new List <StoredProcedure>(); }
public Database(Server server, String name) : base() { this.Server = server; this.Name = IdentifierHelper.GetStrippedSqlIdentifier(name); this._connection = this.Server.Configuration.Connection; }
public StoredProcedure(Schema schema, String name, Int32 versionNumber, SqlParameter[] sqlParameters) : this() { this.Schema = schema; this.Name = IdentifierHelper.GetStrippedSqlIdentifier(name); this.VersionNumber = versionNumber; this.SqlParameters = sqlParameters; this.DoesReturnResultSet = true; this._configuration = this.Schema.Database.Server.Configuration; }
public StoredProcedure AddStoredProcedure(String name, Int32 versionNumber, params SqlParameter[] sqlParameters) { name.Name("name").NotNullEmptyOrOnlyWhitespace(); versionNumber.Name("versionNumber").GreaterThan(0); name = IdentifierHelper.GetBracketedSqlIdentifier(name); if (name.Contains(".")) { throw new ArgumentExceptionFmt(Properties.Resources.InvalidStoredProcedureNameForSchema, name); } if (this.StoredProcedures.GetByName(name, versionNumber) == null) { var sp = new StoredProcedure(this, name, versionNumber, sqlParameters); this.StoredProcedures.Add(sp); return(sp); } else { throw new ExceptionFmt(Properties.Resources.StoredProcedureAlreadyExists, name, versionNumber); } }
/// <summary> /// Create and add a StoredProcedure instance to this Database. /// <para>The name parameter must be a valid one-part or two-part T-SQL identifier. Square brackets around the name parts are optional.</para> /// <para>E.g. "my_stored_proc", "[my_stored_proc]", "my_schema.my_stored_proc", and "[my_schema].[my_stored_proc]" are all valid name identifiers.</para> /// <para>Names with more than two parts, or missing parts, are considered errors.</para> /// </summary> public StoredProcedure AddStoredProcedure(String name, Int32 versionNumber, params SqlParameter[] sqlParameters) { name.Name("name").NotNullEmptyOrOnlyWhitespace(); versionNumber.Name("versionNumber").GreaterThan(0); name = IdentifierHelper.GetStrippedSqlIdentifier(name); var nameParts = name.Split(".".ToCharArray(), StringSplitOptions.None); /* It's an error if any of the name parts are empty, * and this method only accepts one-part ([object name]) or * two-part ([schema name].[object name]) T-SQL identifiers. */ if (nameParts.Any(s => s.IsEmpty()) || (nameParts.Length > 2)) { throw new ArgumentExceptionFmt(Properties.Resources.InvalidStoredProcedureName, name); } /* At this point, all of the name parts have been validated for correct form. */ if (nameParts.Length == 1) { return(this.Schemas.GetDefaultSchema().AddStoredProcedure(name, versionNumber, sqlParameters)); } else { var schemaName = nameParts[0]; var schema = this.Schemas.GetByName(schemaName); if (schema == null) { throw new ExceptionFmt(Properties.Resources.SchemaNameNotFound, schemaName); } var storedProcedureName = nameParts[1]; return(schema.AddStoredProcedure(storedProcedureName, versionNumber, sqlParameters)); } }
public Server(Configuration configuration) : base() { IdentifierHelper.Init(configuration); this.Configuration = configuration; }
/// <summary> /// Return a string that can be used in generated code to represent this column as a target language method parameter. /// </summary> private String GetTargetLanguageMethodParameterNameAndType(SqlParameter sqlParameter) { var format = ""; if (this._configuration.TargetLanguage.IsCSharp()) { format = "{0} {1}"; } else if (this._configuration.TargetLanguage.IsFSharp()) { format = "({1} : {0})"; } else if (this._configuration.TargetLanguage.IsVisualBasic()) { format = "{1} As {0}"; } else { throw new NotImplementedException(String.Format(Properties.Resources.UnknownTargetLanguageValue, this._configuration.TargetLanguage)); } return(String.Format(format, this.GetClrTypeNameFromSqlDbType(sqlParameter), IdentifierHelper.GetTargetLanguageIdentifier(sqlParameter.ParameterName)).Trim()); }