On Fri, 16 Sep 2016 at 13:36 Greg Keogh <gfke...@gmail.com> wrote: > >> >>> What can bridge the "impedance" gap? Something has to. >>> >> >> I agree. It is called effort. >> > > Come on David ... *effort* into what exactly? What tool, technology, kit, > gizmo? I need more detail. I'm a coder. I've got to drag stuff in and out > of databases that I don't own and didn't design and are probably normalized > to 12th normal form and are works of art. If I don't use an ORM, what the > hell do I code? >
Write a structured data access layer as stored procs. Use something like dapper to wrap them in a class automatically. > File -> New -> Project -> SQL Server Database Project. Prepare to be >> amazeballsed. >> > > I've only ever seen a colleague use one of these to write code that > migrated an Oracle database to SQL Server. I never looked inside it. Am I > missing something good (for coders)? > All the things you said were bad about stored procs are fixed by those projects. Everything is versioned independently. David. -- David Connors da...@connors.com | @davidconnors | LinkedIn | +61 417 189 363
