EfueliteSolutionsDBReader 1.0.0

Efuelite Solutions Database Reader

This is a simple to implement, lightweight and highly efficient package used to handle data conversion and null values when reading data from databases such as Microsoft Sql, MySql and Oracle in .Net applications to Database

Usage

1. In class where Efuelite Solutions Database Reader is to be used, just import the name space EfueliteSolutionsDBReader. using EfueliteSolutionsDBReader;

2. There are methods to read data from Microsoft Sql, My Sql and Oracle databases for different data types and convert them to different variable type in C# while handling null values.

Conversion to String variable

• To handle data conversion from database value to String variable type in C#, simply use as,
• string MyStringVariable = DB.DBString(DbReaderVariable, "DatabaseStringColumnName");
• You can supply a default value such as,
• string MyStringVariable = DB.DBString(DbReaderVariable, "DatabaseStringColumnName", YourDefaultValue);
• When the database column is null, your default value is returned.
• If no default value is given, then a safe empty string is returned.

Conversion to Integer variable

• To handle data conversion from database value to Integer variable type in C#, simply use as,
• int MyIntegerVariable = DB.DBInteger(DbReaderVariable, "DatabaseIntegerColumnName");
• You can supply a default value such as,
• int MyIntegerVariable = DB.DBInteger(DbReaderVariable, "DatabaseIntegerColumnName", YourDefaultValue);
• When the database column is null, your default value is returned.
• If no default value is given, then an Integer of zero is returned.

Conversion to DateTime variable

• To handle data conversion from database value to DateTime variable type in C#, simply use as,
• DateTime MyDateTimeVariable = DB.DBDateTime(DbReaderVariable, "DatabaseDateTimeColumnName");
• You can supply a default value such as,
• DateTime MyDateTimeVariable = DB.DBDateTime(DbReaderVariable, "DatabaseDateTimeColumnName", YourDefaultValue);
• When the database column is null, your default value is returned.
• If no default value is given, then a DateTime of value 1900-01-01 is returned.

Conversion to Boolean variable

• To handle data conversion from database value to Boolean variable type in C#, simply use as,
• bool MyBooleanVariable = DB.DBBoolean(DbReaderVariable, "DatabaseBooleanColumnName");
• You can supply a default value such as,
• bool MyBooleanVariable = DB.DBBoolean(DbReaderVariable, "DatabaseBooleanColumnName", YourDefaultValue);
• When the database column is null, your default value is returned.
• If no default value is given, then a Boolean of value false is returned.

Conversion to Decimal variable

• To handle data conversion from database value to Decimal variable type in C#, simply use as,
• decimal MyDecimalVariable = DB.DBDecimal(DbReaderVariable, "DatabaseDecimalColumnName");
• You can supply a default value such as,
• decimal MyDecimalVariable = DB.DBDecimal(DbReaderVariable, "DatabaseDecimalColumnName", YourDefaultValue);
• When the database column is null, your default value is returned.
• If no default value is given, then a Decimal of value 0.00 is returned.

Conversion to Double variable

• To handle data conversion from database value to Double variable type in C#, simply use as,
• double MyDoubleVariable = DB.DBDouble(DbReaderVariable, "DatabaseDoubleColumnName");
• You can supply a default value such as,
• double MyDoubleVariable = DB.DBDouble(DbReaderVariable, "DatabaseDoubleColumnName", YourDefaultValue);
• When the database column is null, your default value is returned.
• If no default value is given, then a Double of value 0.00 is returned.