GetDatabaseObjectName() публичный Метод

Determines the database stored procedure name
public GetDatabaseObjectName ( ) : string
Результат string
Документация по классу CustomStoredProcedure
Пример #1
0
        public static string GetSQLCreateStoredProc(CustomStoredProcedure storedProcedure, bool isInternal)
        {
            var sb = new StringBuilder();
            var name = storedProcedure.GetDatabaseObjectName();

            sb.AppendLine("if exists(select * from sys.objects where name = '" + name + "' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')");
            sb.AppendLine("drop procedure [" + storedProcedure.GetSQLSchema() + "].[" + name + "]");
            if (isInternal)
            {
                sb.AppendLine("--MODELID: " + storedProcedure.Key);
            }
            sb.AppendLine("GO");
            sb.AppendLine();
            sb.AppendLine("CREATE PROCEDURE [" + storedProcedure.GetSQLSchema() + "].[" + name + "]");

            if (storedProcedure.Parameters.Count > 0)
            {
                sb.AppendLine("(");
                sb.Append(BuildStoredProcParameterList(storedProcedure));
                sb.AppendLine(")");
            }

            sb.AppendLine("AS");
            sb.AppendLine();
            sb.Append(storedProcedure.SQL);
            sb.AppendLine();
            if (isInternal)
            {
                sb.AppendLine("--MODELID,BODY: " + storedProcedure.Key);
            }
            sb.AppendLine("GO");
            sb.AppendLine();
            return sb.ToString();
        }