Question

i want to let the user select atable and then select only some columns of this table with specific order then export the data to csv file
also the user can import from csv file

it is easy by direct way with dynamic sql statements but how can i do that with dataobjects

Answer 1

Hello mnady,

First, you will need a domain model for your database, so every table must be described as a separate persistent type (entity).

Second, when you get a list of columns to export, you do the following:

 List<string> columns; // a list of columns to export

 using (var session = Domain.OpenSession()) {
    using (var t = session.OpenTransaction() {

        var items = session.Query.All<Customer>();
        foreach (var item in items) {
            var values = new List<string>();
            foreach (string column in columns) {
                values.Add(item[column]).ToString();
            }
            cvsfile.AddLine(values.Join(','));
        }
        t.Complete();
    }
 }

The import routine is the opposite to this one.

Subscription:

Related questions