How to excute store proceduced via odbc?

[minhdanghuu]

I have a problem when excute store proceduced with parameter via odbc. Some have had mention in #571 , but i can't figure out how to make it work in store procedured. Can someone provided me an worked example ?

[luoyunchong]

DbParameter p2 = null;
fsql.Ado.CommandFluent("dbo.GetICMaxNum")
    .CommandType(CommandType.StoredProcedure)
    .CommandTimeout(60)

    .WithParameter("TableName", "tb1")
    .WithParameter("FInterID", null, p =>
    {
        p2 = p; //Output Parameter
        p.DbType = DbType.Int32;
        p.Direction = ParameterDirection.Output;
    })
    .ExecuteNonQuery(); //.Query<T>() 或者 .ExecuteDataTable() 或者 ...

Console.WriteLine(p2.Value);