1. implement an operation to read the records from the file. Inherit
AbstractOperation and use the FluentEngine API to read the file.
2. pick one of the Database out commands to insert the records in to the
database. If it's a sql db I usually go for ConventionSqlBatchOperation.
That's my preference over SqlBulkInsert.
If you are using the convention methods you may want an intermediate
operation to change the field names from whatever was imported from file to
the parameter names of the insert statement.
3. implement an ETL process that uses these operations.
4. run the process.
here is an example
class MyProcess: EtlProcess
{
public void Register()
{
Register(new ReadFileOperation());
Register(new ConventionSqlBatchOperation(connection string name)
{ BatchSize = 250, Command = "insert into [table] ([column1], [column2])
values (@value1, @value2);" });
}
}
class ReadFileOperation : AbstractOperation
{
//going from memory so this could be wrong, but it looks something like
this...
public IEnumerable<Row> void Execute(IEnumerbale<Row> rows)
{
return FluentEngine<Dto>().Read(file name);
}
}
//to run from C#
new MyProcess().Execute();
On Friday, November 2, 2012 6:16:59 AM UTC-4, Bill wrote:
>
> Hi,
> Could someone point me towards a simple example of importing a file and
> outputting it to a database table? Just getting started - looks great but
> just trying to get my head around it. I need to better understand how DB
> connections are made, how the schema is used, etc.
>
> Thanks!
>
--
You received this message because you are subscribed to the Google Groups
"Rhino Tools Dev" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rhino-tools-dev/-/sMgOMv_VbmQJ.
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.
