Reading CSV File using Entiry Framework 4.0

Question

Hi,

Is it possible to read CSV file using Entiry Framework 4 such that it should give me an entity that I can use it normally within my application?

Thanks

Answer 1

I don't think that there is a CSV adapter for EF4, but you could always use a Linq-to-CSV concept for small CSV files. The results of your queries could be mapped into your EF objects and written to tables or just used in your data access layer as an additional data source.