** Mods, if for any reason this question is inappropriate, please leave a comment rather than putting it on hold and I will make the change according to your suggestion. Thank you.

Hi all

I have been reading a lot about repository implementation. I am confused about which way to implement it for a project I am sure would change its data layer methods because of db migration from MS Sql Server to NoSQL one in couple of years

Imp #1
------

 - Implement Rep layer as a completely separate layer. This will have
   its own interface and conversion methods here. This rep layer has a
   dependency on DAL and in turn BLL will have a dependency on this
   layer

Imp#2
-----

 - Implement Repository not as a separate layer but have its interfaces
   in Business Logic Layer and the methods in DAL.

I am gearing more towards imp #1 since it looks cleaner. However some explanations of experts I have read use the imp#2. I think there must be a clear reason to use one over another according to the situation. I would ideally want our switch to a different database as painless as possible basically. Thank you all :)