using System;

​

//sample usage of referencing SPs in code

var sp1 = Database.LoggingDB.Marketing.usp_Whatever;

var sp2 = Database.SettingsDB.dbo.usp_MySP;

var sp3 = Database.SettingsDB.MySecondSP;

​

public class SPAttribute : Attribute

{

    public string Schema { get; set; } = "dbo";

    //optionally add field for db name

}

​

public static class Database

{

    public static class SettingsDB

    {

        public class dbo // schema

        {

            [SP]

            public const string usp_MySP = "usp_whatever_33";

        }

​

        [SP] // default schema is dbo

        public const string usp_MySPWithDefaultSchema = "usp_whatever_33";

        [SP(Schema = "myschema")]

        public const string MySecondSP = "usp_foobar_21";

    }

​

    public static class LoggingDB

    {

        public class Marketing // schema

        {

            [SP]

            public const string usp_Whatever = "dbo.usp_Whatever44"; //not a good idea but should be supported and override the Marketing schema

        }

    }

}