public static void Initialize() { VerifySqlServer.Enable(); VerifierSettings.ModifySerialization(settings => { settings.AddExtraSettings(serializerSettings => serializerSettings.TypeNameHandling = TypeNameHandling.Objects); }); SqlHelper.EnsureDatabaseExists(Connection.ConnectionString); using var sqlConnection = Connection.OpenConnection(); var manager = new QueueManager("error", sqlConnection); manager.Create().Await(); }
public static void Init() { VerifySqlServer.Enable(); }
static Tests() { #region Enable VerifySqlServer.Enable(); #endregion sqlInstance = new( "VerifySqlServer", connection => { Server server = new(new ServerConnection((SqlConnection)connection)); server.ConnectionContext.ExecuteNonQuery(@" CREATE TABLE MyTable(Value int); GO CREATE INDEX MyIndex ON MyTable (Value); GO INSERT INTO MyTable (Value) VALUES (42); GO CREATE TRIGGER MyTrigger ON MyTable AFTER UPDATE AS RAISERROR ('Notify Customer Relations', 16, 10); GO CREATE VIEW MyView AS SELECT Value FROM MyTable WHERE (Value > 10); GO create synonym synonym1 for MyTable; GO CREATE PROCEDURE MyProcedure AS BEGIN SET NOCOUNT ON; SELECT Value FROM MyTable WHERE (Value > 10); END; GO CREATE FUNCTION MyFunction( @quantity INT, @list_price DEC(10,2), @discount DEC(4,2) ) RETURNS DEC(10,2) AS BEGIN RETURN @quantity * @list_price * (1 - @discount); END;"); return(Task.CompletedTask); }); }