SalarDbCodeGenerator.DbProject.ProjectDbSettions.GetConnectionString C# (CSharp) Method

        public string GetConnectionString()
        {
            string connStr = "";
            switch (DatabaseProvider)
            {
                case DatabaseProvider.SQLServer:
                    if (UseSqlAuthentication)
                        connStr = string.Format("Data Source={0};Initial Catalog={1};User ID={2};Pwd={3};Connect Timeout={4}",
                            ServerName,
                            DatabaseName,
                            SqlUsername,
                            SqlPassword,
                            ConnectTimeout
                        );
                    else
                        connStr = string.Format("Data Source={0};Initial Catalog={1};Integrated Security=True;Connect Timeout={2}",
                            ServerName,
                            DatabaseName,
                            ConnectTimeout
                        );
                    break;

                case DatabaseProvider.SqlCe4:
                    if (UseSqlAuthentication)
                        connStr = string.Format("Data Source={0};Password={1}",
                            ServerName,
                            SqlPassword
                        );
                    else
                        connStr = string.Format("Data Source={0};",
                            ServerName
                        );
                    break;

                case DatabaseProvider.Oracle:
                    const string connSpecificUser = "Data Source={0};User Id={1};Password={2};";
                    const string connIntegratedSecurity = "Data Source={0};Integrated Security=SSPI;";
                    const string connDbaPrivilege = "DBA PRIVILEGE=SYSDBA;";

                    if (UseSqlAuthentication)
                    {
                        connStr = string.Format(connSpecificUser, ServerName, SqlUsername, SqlPassword);
                    }
                    else
                        connStr = string.Format(connIntegratedSecurity, ServerName);

                    if (OracleUseSysdbaRole)
                        connStr += connDbaPrivilege;

                    break;

                case DatabaseProvider.SQLite:
                    connStr = string.Format("data source=={0};Default Timeout={1}",
                        ServerName,
                        ConnectTimeout
                    );

                    break;
            }
            return connStr;
        }