I am using the LLBLGEN generated DTO classes. I am having a method to save multiple records to the database.

I am passing the List<DTO> to the method. How do I save this to the database. If it was a collection I should use adapter.SaveEntityCollection. Is there a way I could convert to List<DTO> to EntityCollection<Entity>

thanks Sam

Hi Sam,

You can't save DTO's as they don't have any persistence information. You will have to iterate your list, create entities for each DTO and add them to a EntityCollection, then you can save the EntityCollection.

Thanks for your quick reply. Is there any examples I can find in your website or Help.

Pretty straight forward

    public void SaveData(List<YourEntityDTO> dtoList)
    {
        YourEntityCollection coll = new YourEntityCollection();
        dtoList.ForEach(dto => coll.Add(new YourEntity(dto)));
        coll.SaveMulti();
    }

Looks pretty straight forward. But I am getting an error. below is example I did and I got best overloaded method have invalid arguments at line empList.Foreach.

public void SaveEmp(List<EmpDTO> empList) { bool success = false; EntityCollection<EmpEntity> empCollection = new EntityCollection<EmpEntity>(); empList.ForEach(dto => empCollection.Add(new EmpEntity(dto)));

            using (DataAccessAdapter adapter = new DataAccessAdapter())
            {
                success = adapter.SaveEntityCollection(empCollection);
            }
        }

I think I am doing something wrong. Since I am new to .Net and LLBLGEN I am not able to figure this out.

Thanks for the help

Which version of .NET framework are you using? Can you please send the stack trace?

I am using .Net frame work 3.5. I am not able to compile this because of the error.

No Entity constructor receives a DTO, that's why your compilation error. The idea is this:

bool success = false;
EntityCollection<EmpEntity> empCollection = new EntityCollection<EmpEntity>();
foreach (var x in empList)
{
     EmpEntity e = new EmpEntity();
     e.EmpId = x.EmpId;
     e.AnotherField = x.Anotherfield;
     ...
     empCollection.Add(e);  
}

using (DataAccessAdapter adapter = new DataAccessAdapter())
{
     success = adapter.SaveEntityCollection(empCollection);             
}

Thanks. that worked.