Data Provider for Oracle не добавлен в приведённый выше список не из соображений консолидации с Microsoft в священной борьбе против Oracle, а по причине реализации этого провайдера в отдельной сборке, подключение которой приведёт так же к необходимости её подключения ко всем проектам, которые будут использовать Rsdn.Framework.Data

M>Data Provider for Oracle не добавлен в приведённый выше список не из соображений консолидации с Microsoft в священной борьбе против Oracle, а по причине реализации этого провайдера в отдельной сборке, подключение которой приведёт так же к необходимости её подключения ко всем проектам, которые будут использовать Rsdn.Framework.Data

IDataReader reader = db.ExecuteSpReader("sp_help", "MyTable");
ArrayList tables  = db.GetObjectList(reader, typeof(MyTableInfoClass));
ArrayList columns = db.GetObjectList(reader, typeof(MyColumnInfoClass));
reader.NextResult();  // we are skipping this result set because we want go to index information
reader.NextResult();  // we are skipping this result set because we want go to index information
reader.NextResult();  // we are skipping this result set because we want go to index information
reader.NextResult();  // we are skipping this result set because we want go to index information
ArrayList indexes = db.GetObjectList(reader, typeof(MyIndexInfoClass));

// null type means that we will skip next result set.
Type[] types = new Type[3] {typeof(MyTableInfoClass), typeof(MyColumnInfoClass), null, null, null, typeof(MyIndexInfoClass)}
ArrayList objects = db.ExecuteSpList(types, "sp_help", "MyTable"); // returns ArrayList of ArrayLists
MyTableInfoClass table = (ArrayList[0] as ArrayList)[0];
table.Columns = (ArrayList[1] as ArrayList);
table.Indexes = (ArrayList[5] as ArrayList);

        public static IList MapList(IDataReader reader, IList list, Type type)
        {
            if (reader.Read())
            {
                Mapping.DataReaderSource drs = new Mapping.DataReaderSource(reader);
                Mapping.TypeDescriptor   td  = Mapping.TypeDescriptor.GetDescriptor(type);

                do
                {
                    object o = td.CreateInstance();

                    MapData.Map(drs, reader, td, o);

                    list.Add(o);
                } while (reader.Read());
            }

            return list;
        }

        public static ArrayList MapList(IDataReader reader, Type type)
        {
            ArrayList arrayList = new ArrayList();

            MapList(reader, arrayList, type);

            return arrayList;
        }

using System;
using System.Data;
using System.Collections;
 
using Rsdn.Framework.Data;
using Rsdn.Framework.Data.DataProvider;

namespace Example
{
    public class Category
    {
        [MapField(Name = "CategoryID")]
        public int    ID;

        public string CategoryName;

        [MapField(IsNullable = true)]
        public string Description;
    }

    class Test
    {
        static void Main()
        {
            using (DbManager   db = new DbManager())
            using (IDataReader dr = db.ExecuteReader(@"
                SELECT
                    CategoryID,
                    CategoryName,
                    Description
                FROM Categories

                SELECT
                    CategoryID,
                    CategoryName
                FROM Categories"))
            {
                ArrayList al = MapData.MapList(dr, typeof(Category));

                foreach (Category c in al)
                    Console.WriteLine("{0,2}  {1,-15} {2}", c.ID, c.CategoryName, c.Description);

                if (dr.NextResult())
                {
                    al = MapData.MapList(dr, typeof(Category));

                    foreach (Category c in al)
                        Console.WriteLine("{0,2}  {1,-15} {2}", c.ID, c.CategoryName, c.Description);
                }
            }
        }
    }
}

    public class testID
    {
        public int ID;

        public testID(int ID)
        {
            this.ID = ID;
        }
    }

// .....

        IDbDataParameter[] pars =
            manager.CreateParameters(new testID(51));

public class testID
{
    public int ID;

    public testID(int ID)
    {
        this.ID = ID;
    }
}

[Test]
public void CreateParameters()
{
    using (DbManager db = new DbManager(ConfigurationString))
    {
        IDbDataParameter[] pars = db.CreateParameters(new testID(51));

        Console.WriteLine(pars[0].Value);

        Assert.IsTrue((int)pars[0].Value == 51);
    }
}

IT>Странно, вот такой тест у меня работает как часы

IT>public class testID
IT>{
IT>    public int ID;

IT>    public testID(int ID)
IT>    {
IT>        this.ID = ID;
IT>    }
IT>}

IT>[Test]
IT>public void CreateParameters()
IT>{
IT>    using (DbManager db = new DbManager(ConfigurationString))
IT>    {
IT>        IDbDataParameter[] pars = db.CreateParameters(new testID(51));

IT>        Console.WriteLine(pars[0].Value);

IT>        Assert.IsTrue((int)pars[0].Value == 51);
IT>    }
IT>}
IT>

public struct testID

    public int ID;

    public testID(int ID)
    {
        this.ID = ID;
    }

        public static string GetMappedFieldName(
            string FieldName, Type BizType)

    public class BizEntity
    {
        [MapField("ident")]
        public int    ID;
        public string Name;
    }

SAV>        public static string GetMappedFieldName(
SAV>            string FieldName, Type BizType)
SAV>

        public static string GetMappedFieldName(
            string FieldName, Type BizType)
        {
            TypeDescriptor td = TypeDescriptor.GetDescriptor(BizType);
            string tdName = string.Format(
                "{0}.MemberDescriptor.{1}", BizType.FullName, FieldName);
            
            for (int i = 0; i<td.MemberList.Count; i++ )
                if (((IMemberDescriptor)td.MemberList[i]).ToString() == tdName)
                    return (td as IDataSource).GetFieldName(i);

            return null;
        }

/// <summary>
/// Updates database from the given dataset using provided UPDATE, INSERT and
/// DELETE SQL statements with provided parameters.
/// </summary>
/// <param name="dataSet">The DataSet object used to update database.</param>
/// <param name="tableName">The name of the populating table.</param>
/// <param name="updateCommandType">The <see cref="System.Data.CommandType">CommandType</see> (stored procedure, text, etc.) for update operation.</param>
/// <param name="insertCommandType">The <see cref="System.Data.CommandType">CommandType</see> (stored procedure, text, etc.) for insert operation.</param>
/// <param name="deleteCommandType">The <see cref="System.Data.CommandType">CommandType</see> (stored procedure, text, etc.) for delete operation.</param>
/// <param name="updateCommandText">The command text to execute in case of update operation.</param>
/// <param name="insertCommandText">The command text to execute in case of insert operation.</param>
/// <param name="deleteCommandText">The command text to execute in case of delete operation.</param>
/// <param name="updateCommandParameters">An array of paramters used to executes the update command.</param>
/// <param name="insertCommandParameters">An array of paramters used to executes the insert command.</param>
/// <param name="deleteCommandParameters">An array of paramters used to executes the delete command.</param>
/// <returns>The <see cref="DataSet"/>.</returns>
public DataSet UpdateDataSet(
    DataSet     dataSet,
    string      tableName,
    CommandType updateCommandType,
    CommandType insertCommandType,
    CommandType deleteCommandType,
    string      updateCommandText,
    string      insertCommandText,
    string      deleteCommandText,
    IDbDataParameter[] updateCommandParameters,
    IDbDataParameter[] insertCommandParameters,
    IDbDataParameter[] deleteCommandParameters)
{
    PrepareUpdateCommands(updateCommandType,
        insertCommandType, deleteCommandType,
        updateCommandText, insertCommandText,
        deleteCommandText,
        updateCommandParameters, insertCommandParameters,
        deleteCommandParameters);

    return UpdateDataSetInternal(dataSet, tableName);
}

using (DbManager db = CreateDataDbManager())
{
db.UpdateDataSet(
    dataSet, "Employees", CommandType.Text, CommandType.Text,
    CommandType.Text, GetProviderString("UpdateEmployee"),
    GetProviderString("InsertEmployee"),
    GetProviderString("DeleteEmployee"),
    new IDbDataParameter[]
    {
        db.Parameter("Title_ID", DbType.Int32, "Title_ID"),
        db.Parameter("FirstName", DbType.String, 50, "FirstName"),
        db.Parameter("LastName", DbType.String, 50, "LastName"),
        db.Parameter("Comments", DbType.String, 100, "Comments"),
        db.Parameter("ID", DbType.Int32, "ID")
    },
    new IDbDataParameter[]
    {
        db.Parameter("Title_ID", DbType.Int32, "Title_ID"),
        db.Parameter("FirstName", DbType.String, 50, "FirstName"),
        db.Parameter("LastName", DbType.String, 50, "LastName"),
        db.Parameter("Comments", DbType.String, 100, "Comments")
    },
    new IDbDataParameter[]
    {
        db.Parameter("ID", DbType.Int32, "ID")
    }
    );
}

public object[] Select(ICollection tableList, string filter, string sort)

public IDbDataParameter Parameter(string parameterName, DbType dbType, object value);
public IDbDataParameter Parameter(string parameterName, DbType dbType, int size, object value);

string AdjustSqlParameter(string parameter);

public DataSet UpdateSpDataSet(
    DataSet     dataSet,
    string      tableName,
    string      insertSpName,
    string      updateSpName,
    string      deleteSpName,
    IDbDataParameter keyField,
    IDbDataParameter[] commandParameters)
{}

public DataSet UpdateDataSet(
    DataSet     dataSet,
    string      tableName,
    string      insertCommandText,
    string      updateCommandText,
    string      deleteCommandText,
    IDbDataParameter keyField,
    IDbDataParameter[] commandParameters)
{}

using (DbManager db = CreateDataDbManager())
{
db.UpdateDataSet(
    dataSet, "Employees", "InsertEmployee", "UpdateEmployee", "DeleteEmployee",
    db.Parameter("ID", DbType.Int32, "ID"),
        db.Parameter("Title_ID", DbType.Int32, "Title_ID"),
        db.Parameter("FirstName", DbType.String, 50, "FirstName"),
        db.Parameter("LastName", DbType.String, 50, "LastName"),
        db.Parameter("Comments", DbType.String, 100, "Comments")
    );
}

using (DbManager db = new DbManager())
{
    return db
        .InsertCommand(commandType, "COMMAND TEXT")
        .UpdateCommand(commandType, "COMMAND TEXT")
        .DeleteCommand(commandType, "COMMAND TEXT")
        .ExecutePreparedDataSet();
}

using (DbManager db = new DbManager())
{
    return db
        .InsertCommand("INSERT INTO...", db.CreateParameters(entity))
        .UpdateCommand(CommandType.StoredProcedure, "UpdateItem")
        .DeleteSp("DeleteItem", db.Parameter("@ID"))
        .UpdateDataSet();
}

R>пробовал ExecuteSpScalar и ExecuteSpList — что-то не получается...

[Test]
public void OutputParameter()
{
    using (DbManager db = new DbManager(ConfigurationString))
    {
        db.ExecuteNonQuery(@"
            if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Test]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
            begin
                drop procedure [dbo].[Test]
            end");

        db.ExecuteNonQuery(@"
            CREATE PROCEDURE dbo.Test
                @p1 int,
                @p2 int,
                @po int output
            AS

            SET @po = @p1 * @p2");

        db.ExecuteNonQuery(@"
            GRANT EXEC ON dbo.Test TO PUBLIC");

        db.ExecuteSpNonQuery(
            "Test",
            db.Parameter("@p1", 2),
            db.Parameter("@p2", 2),
            db.OutputParameter("@po", 0));

        object o = db.Parameter("@po").Value;

        Console.WriteLine(o);

        Assert.AreEqual(4, o);
    }
}

CREATE PROCEDURE dbo.Test
    @p1 int,
    @p2 int,
AS

SELECT @p1 * @p2"