Business Logic Toolkit for .NET
www.bltoolkit.net
Welcome Guest, you are in: Login
|  Home   |  Download   |  Documentation   |  Discussions   |  Issues   |  License   |
RSS RSS

Navigation




Search the wiki
»

PoweredBy
The DataSetTable attribute specifies table to be populated by the method in destination or returning dataset.

DataSetTable.cs

using System;
using System.Data;

using NUnit.Framework;

using BLToolkit.DataAccess;

namespace HowTo.DataAccess { [TestFixture] public class DataSetTable { public abstract class TestAccessor : DataAccessor { [SprocName("Person_SelectAll"), DataSetTable("First")] public abstract void SelectFirstTable ([Destination] DataSet ds);

[SprocName("Person_SelectAll"), DataSetTable("Second")] public abstract void SelectSecondTable ([Destination] DataSet ds);

[SprocName("Person_SelectAll"), DataSetTable(0)] public abstract void SelectFirstTable2 ([Destination] DataSet ds);

[SprocName("Person_SelectAll"), DataSetTable(1)] public abstract void SelectSecondTable2([Destination] DataSet ds); }

[Test] public void Test() { TestAccessor ta = DataAccessor.CreateInstance<TestAccessor>();

DataSet ds = new DataSet();

ta.SelectFirstTable (ds); ta.SelectSecondTable (ds); ta.SelectFirstTable2 (ds); ta.SelectSecondTable2(ds);

Assert.IsTrue (ds.Tables.Contains("First"), "Table 'First' not found"); Assert.IsTrue (ds.Tables.Contains("Second"), "Table 'Second' not found"); Assert.IsFalse(ds.Tables.Contains("Table"), "Table 'Table' was found"); } } }

App.config

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <connectionStrings>
        <add
            name             = "DemoConnection"
            connectionString = "Server=.;Database=BLToolkitData;Integrated Security=SSPI"
            providerName     = "System.Data.SqlClient" />
    </connectionStrings>
</configuration>

CreateSql
© 2010 www.bltoolkit.net