public void CreateDataAdapter()
{
IDataAdapterFactory dataAdapterFactory = new SqlServerDataAdapterFactory();
IConnectionFactory connectionFactory = new SqlServerConnectionFactory();
using (var connection = connectionFactory.Open(AppState.ConnectionString))
using (var command = connection.CreateCommand())
using (var dataAdapter = dataAdapterFactory.CreateDataAdapter(command))
{
Assert.IsNotNull(dataAdapter);
Assert.AreEqual(command, dataAdapter.SelectCommand);
}
}
public void Command_CreateParamsFromSqlText()
{
//string sql = "select * from [tb] where [tb].[col] = @ParamOne";
var adapterFactory = new SqlServerDataAdapterFactory();
var connectionFactory = new SqlServerConnectionFactory();
using (var connection = connectionFactory.Open(AppState.ConnectionString))
using (var command = connection.CreateCommand())
using (var adapter = adapterFactory.CreateDataAdapter(command))
{
Assert.IsNotNull(adapter);
Assert.AreEqual(command, adapter.SelectCommand);
}
}
