MySql CompiledQuery

[traufeisen]

Hi,
running a compiled Query more than one time results in a "object disposed" Exception.

Code: Select all

public static Func> GetPerson =
            CompiledQuery.Compile(
                (DataContext1.DataContext1 ctx, int personId) =>
                (from obj in ctx.Persons where obj.Personid == personId select obj)
                );

for (int i = 0; i  person = GetPerson(dataContext1, 1);
	dataContext1.Dispose();
}

The first call works fine, but the second throws an Exception.
It seems, that the compiled Query still uses the old dataContext or is there a trick to run such a Query with a new dataContext?

[AndreyR]

Thank you for the report, we will investigate the situation.

[traufeisen]

I´ve found another problem.
When I use a compiled Query, but select a new object, a Notimplemented-Exception is thrown and there is no possibility to rollback the current Transaction.

Code: Select all

public class Foo
{
    public Foo(int id)
    {
        this.Id = id;
    }

    public int Id;
}
public static Func> GetPerson =
            CompiledQuery.Compile(
                (DataContext1.DataContext1 ctx, int personId) =>
                (from obj in ctx.Persons where obj.Personid == personId select new Foo(obj.PersonId))
                ); 

In case of an Error, I try to Rollback the active Transaction, but calling DataContext.Transaction.Rollback(); throws a MySqlException "Commands out of sync; You can't run this command now".
DataContext.Connection.Close(); doesn´t help. The Connections keeps open. With the Transaction still active.

Is there a way to force a connection-close even if connection-pooling is active?

[AndreyR]

We have fixed both errors. The fixes will be available in the nearest build.