public void CurrencyOracleExtractToFile( ) { GenericDatabaseStorage <OracleConnection, OracleCommand> storage = new GenericDatabaseStorage <OracleConnection, OracleCommand>(typeof(TestRecord), "User Id=SHELL;Password=shell;Data Source=ora9dev"); storage.SelectSql = "SELECT * FROM CURRENCY"; storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder); FileDataLink.EasyExtractToFile(storage, "tempord.txt"); FileDataLink link = new FileDataLink(storage); link.ExtractToFile("tempord.txt"); TestRecord[] res = CommonEngine.ReadFile(typeof(TestRecord), "tempord.txt") as TestRecord[]; if (File.Exists("tempord.txt")) { File.Delete("tempord.txt"); } Assert.AreEqual(3, res.Length); Assert.AreEqual("AED", res[0].CurrencyCode); Assert.AreEqual("AFA", res[1].CurrencyCode); Assert.AreEqual("ALL", res[2].CurrencyCode); }
public void CurrencySqlExtractToFile( ) { GenericDatabaseStorage <SqlConnection, SqlCommand> storage = new GenericDatabaseStorage <SqlConnection, SqlCommand>(typeof(TestRecord), "Data Source=FRENZY;Initial Catalog=Pruebas;User Id=sa;Password=Toshiba;"); storage.SelectSql = "SELECT * FROM Currency"; storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder); FileDataLink.EasyExtractToFile(storage, "tempord.txt"); FileDataLink link = new FileDataLink(storage); link.ExtractToFile("tempord.txt"); TestRecord[] res = CommonEngine.ReadFile(typeof(TestRecord), "tempord.txt") as TestRecord[]; if (File.Exists("tempord.txt")) { File.Delete("tempord.txt"); } Assert.AreEqual(105, res.Length); Assert.AreEqual("AED", res[0].CurrencyCode); Assert.AreEqual("AFA", res[1].CurrencyCode); Assert.AreEqual("ALL", res[2].CurrencyCode); }
public void CurrencyOracleExtract( ) { GenericDatabaseStorage<OracleConnection, OracleCommand> storage = new GenericDatabaseStorage<OracleConnection, OracleCommand>( typeof( TestRecord ), "User Id=SHELL;Password=shell;Data Source=ora9dev" ); storage.SelectSql = "SELECT * FROM CURRENCY"; storage.FillRecordCallback = new FillRecordHandler( FillRecordOrder ); TestRecord[ ] res = storage.ExtractRecords( ) as TestRecord[ ]; Assert.AreEqual( 3, res.Length ); Assert.AreEqual( "AED", res[ 0 ].CurrencyCode ); Assert.AreEqual( "AFA", res[ 1 ].CurrencyCode ); Assert.AreEqual( "ALL", res[ 2 ].CurrencyCode ); }
public void CurrencySqlExtract( ) { GenericDatabaseStorage<SqlConnection, SqlCommand> storage = new GenericDatabaseStorage<SqlConnection, SqlCommand>( typeof( TestRecord ), "Data Source=FRENZY;Initial Catalog=Pruebas;User Id=sa;Password=Toshiba;" ); storage.SelectSql = "SELECT * FROM Currency"; storage.FillRecordCallback = new FillRecordHandler( FillRecordOrder ); TestRecord[ ] res = storage.ExtractRecords( ) as TestRecord[ ]; Assert.AreEqual( 105, res.Length ); Assert.AreEqual( "AED", res[ 0 ].CurrencyCode ); Assert.AreEqual( "AFA", res[ 1 ].CurrencyCode ); Assert.AreEqual( "ALL", res[ 2 ].CurrencyCode ); }
public void CurrencyOracleExtract( ) { GenericDatabaseStorage <OracleConnection, OracleCommand> storage = new GenericDatabaseStorage <OracleConnection, OracleCommand>(typeof(TestRecord), "User Id=SHELL;Password=shell;Data Source=ora9dev"); storage.SelectSql = "SELECT * FROM CURRENCY"; storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder); TestRecord[] res = storage.ExtractRecords( ) as TestRecord[]; Assert.AreEqual(3, res.Length); Assert.AreEqual("AED", res[0].CurrencyCode); Assert.AreEqual("AFA", res[1].CurrencyCode); Assert.AreEqual("ALL", res[2].CurrencyCode); }
public void CurrencySqlExtract( ) { GenericDatabaseStorage <SqlConnection, SqlCommand> storage = new GenericDatabaseStorage <SqlConnection, SqlCommand>(typeof(TestRecord), "Data Source=FRENZY;Initial Catalog=Pruebas;User Id=sa;Password=Toshiba;"); storage.SelectSql = "SELECT * FROM Currency"; storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder); TestRecord[] res = storage.ExtractRecords( ) as TestRecord[]; Assert.AreEqual(105, res.Length); Assert.AreEqual("AED", res[0].CurrencyCode); Assert.AreEqual("AFA", res[1].CurrencyCode); Assert.AreEqual("ALL", res[2].CurrencyCode); }
public void CurrencyOracleExtractToFile( ) { GenericDatabaseStorage<OracleConnection, OracleCommand> storage = new GenericDatabaseStorage<OracleConnection, OracleCommand>( typeof( TestRecord ), "User Id=SHELL;Password=shell;Data Source=ora9dev" ); storage.SelectSql = "SELECT * FROM CURRENCY"; storage.FillRecordCallback = new FillRecordHandler( FillRecordOrder ); FileDataLink.EasyExtractToFile( storage, "tempord.txt" ); FileDataLink link = new FileDataLink( storage ); link.ExtractToFile( "tempord.txt" ); TestRecord[ ] res = CommonEngine.ReadFile( typeof( TestRecord ), "tempord.txt" ) as TestRecord[ ]; if ( File.Exists( "tempord.txt" ) ) File.Delete( "tempord.txt" ); Assert.AreEqual( 3, res.Length ); Assert.AreEqual( "AED", res[ 0 ].CurrencyCode ); Assert.AreEqual( "AFA", res[ 1 ].CurrencyCode ); Assert.AreEqual( "ALL", res[ 2 ].CurrencyCode ); }
public void CurrencySqlExtractToFile( ) { GenericDatabaseStorage<SqlConnection, SqlCommand> storage = new GenericDatabaseStorage<SqlConnection, SqlCommand>( typeof( TestRecord ), "Data Source=FRENZY;Initial Catalog=Pruebas;User Id=sa;Password=Toshiba;" ); storage.SelectSql = "SELECT * FROM Currency"; storage.FillRecordCallback = new FillRecordHandler( FillRecordOrder ); FileDataLink.EasyExtractToFile( storage, "tempord.txt" ); FileDataLink link = new FileDataLink( storage ); link.ExtractToFile( "tempord.txt" ); TestRecord[ ] res = CommonEngine.ReadFile( typeof( TestRecord ), "tempord.txt" ) as TestRecord[ ]; if ( File.Exists( "tempord.txt" ) ) File.Delete( "tempord.txt" ); Assert.AreEqual( 105, res.Length ); Assert.AreEqual( "AED", res[ 0 ].CurrencyCode ); Assert.AreEqual( "AFA", res[ 1 ].CurrencyCode ); Assert.AreEqual( "ALL", res[ 2 ].CurrencyCode ); }