I am using 3 layered architecture in c# winforms.
I have created 3 different projects as these layers (UI, BLL, DAL)
BLL referenced in UI.
DAl referenced in BLL.
I already have the database of having around 150 tables.
Some tables having more than 100 fields.
I want to pass data from UI to BLL to DAL and back as well.
If i create classes for each table in BLL, that will be a mess for me as its lot of fields.
And if i created classes in BLL, i can pass from UI to BLL. But then how to pass to DAL
with out creating another model in DAL?.
Will EF work here for me?
If it works, shall i create the EDMX as a separate project? or simply in DAL?.
Another case is, my company has 3 out lets. Each location is having different database,
but same structure.
If i create EF, i need to select the database there na. But will it work at my another outlet, when i
compile it and run the setup at the outlet?.
The database names and paths may be different in each locations.
What I have tried:
i have tried using parametric field values passing to DAL from BLL, but its a hectic job. Need a quicker solution to it without creating another model in DAL.