Hi
I'm trying to write an ETL job using Rhino ETL.
To Read the input table from mySql i use
public class ReadUsers : InputCommandOperation
{
....
protected override void PrepareCommand(IDbCommand cmd)
{
cmd.CommandText = "SELECT * FROM Users";
}
}
To write to SqlServer i inherit from AbstractOperation. Inside i
create an object from my DAL.
public override IEnumerable<Row> Execute(IEnumerable<Row> rows)
{
foreach (Row r in rows)
{
myDalUserObject u=new myDalUserObject();
u.dateOfBirth=r["dateOfBirth"].ToString();<--------------
here is my question : i want DateTime
}
The question is how can i preserve the original datatype ? If i
can't what is the best way to cast ? It looks painful to do it for
each field.
Thanks
Jonathan
--
You received this message because you are subscribed to the Google Groups
"Rhino Tools Dev" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rhino-tools-dev?hl=en.
