End-User Documentation

Migrate to v2 Facade-First Usage

Migrate to v2 Facade-First Usage

QueryLens v2 centers the public experience on the static QueryLens facade plus statement wrappers.

Before

Think in terms of builder-style setup and validator instances.

After

Think in terms of:

  • QueryLens.Dialect
  • QueryLens.LoadDbSchemaFrom(...)
  • QueryLens.Reset()
  • SqlQuery, SqlInsert, SqlUpdate, SqlDelete, SqlMerge, SqlStoredProc

Example

QueryLens.Dialect = DialectProfile.SqlServer2019;
QueryLens.LoadDbSchemaFrom(connectionString);

var query = new SqlQuery("SELECT * FROM dbo.orders WHERE order_id = @Id");
Assert.True(query.IsValid);

Related