Get DialectProvider database type

sviluppo1 · December 28, 2018, 11:54am

I’m developing a custom extension method for SqlExpression and I need to get which database type is targeted by the query DialectProvider.

How can I do that?

The reason is because I need to write some db functions that you currently don’t support, and I need to get which DBMS I’m targeting.

Thanks

mythz · December 29, 2018, 5:56am

It’s tied to DB Provider when it’s created and needs to be passed in the constructor:

github.com

ServiceStack/ServiceStack.OrmLite/blob/master/src/ServiceStack.OrmLite.SqlServer/SqlServerOrmLiteDialectProvider.cs#L101


                }
                continue;
            }
            connectionString += option.Key + "=" + option.Value + ";";
        }
    }


    return new SqlConnection(connectionString);
}


public override SqlExpression<T> SqlExpression<T>() => new SqlServerExpression<T>(this);


public override IDbDataParameter CreateParam() => new SqlParameter();


public override string ToTableNamesStatement(string schema)
{
    var sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'";


    return schema != null 
        ? sql + " AND TABLE_SCHEMA = {0}".SqlFmt(this, schema) 
        : sql;

sviluppo1 · January 7, 2019, 2:00pm

I’m sorry but I could not understand your answer.

Right now I’m using something like that:

switch (query.DialectProvider)
{
    case SqlServerOrmLiteDialectProvider _:
    ... bla bla
    case PostgreSqlDialectProvider _:
    ... bla bla
}

It seems a bit “forced” to me…