I've been Installing/configuring MSSQL with TCPIP and accessing it just fine in C#. But I've seen references that make me believe that it's possible to access a MSSQL .mdf file directly and not using named pipes or TCPIP. Is this true?
It's come more to light while working on my install routing using innosetup. In one of the examples I was referring to it appears that innosetup creates the DB outside of mssql 2008 express after mssql 2008r2 express was installed.
Then in another part I saw some code prototyping that appeared to access the MDF file directly. Is this still using MSSQL 2008 just not the server or what?