SQL object mapper - select table

How to select or display a Person table

First we need to design blueprint of table schema as a class,
Example : Person table with columns : PersonID (PK), FirstName, Status, LeaderID (FK)

[Table("Person")]
public class Person
{

[Column("PersonId", DbType.Int32, false, PrimaryKey = true)]
private Column _personId;

[Column("FirstName", DbType.String, true)]
private Column _firstName;

[Column("Status", DbType.Boolean, true)]
private Column _status;

[Column("LeaderId", DbType.Int32, false, PrimaryKey = true)]
private Column _leaderId;

public Column PersonId { get { return _personId; } }
public Column FirstName { get { return _firstName; } }
public Column LeaderId { get { return _leaderId; } }
public Column Status { get { return _status; } }
public PersonTable()
{ // initialize all fields with ColumnAttribute
Irwsoft.Data.DataFactories.InitTableSchema(this);
}
} 

For more information click here.

This sample codes will show how easy using SQL objects to select Person table :

string connectionString = "...";

// define Person object.
Person person = new Person();

// using SQL-object to select Person table
SqlSelectFrom select = new SqlSelectFrom(person);
// set connection string
select.ConnectionString = connectionString;

// select all columns from Person table
select.Columns.All(person);

// execute select Person table
Irwsoft.Data.DataView dv = select.Execute();

// display record from DataView object on 1st row
string personID_Row_1 = dv.Rows[0][person.PersonId];
string firstName_Row_1 = dv.Rows[0][person.FirstName];

// display record from DataView object on 2nd row
string personID_Row_2 = dv.Rows[1][person.PersonId];
string firstName_Row_2 = dv.Rows[1][person.FirstName];

For more information click here .

•  Previous chapter : About Irwsoft.Data Framework
•  Next chapter : How to use WHERE conditional