Hi Folks
Quick question - I have been working on a project in Visual Studio 2008 for the last year and using SQL Server Express 2008 as my database, but have really come to have a lot of grief trying to distribute it with my executable. I just learned today about LocalDB in SQL Server Express 2012, and it sounds like just what I need for this application. But I have read that I may have trouble trying to use it from VS 2008. That said, those reports seem to indicate that the problem is with trying to use embedded access methods like server browser from visual Studio.
My application has no embedded connections to SQL Server, just connects to it using the system.data.sqlclient namespace and passes the usual connection string info. Assuming this, and assuming I install SQL Server 2012 Express on my system, should I be able to use LocalDB as my data source? Will I need to use a different or updated namespace?
Thanks for any help with this you can provide. This might really be a huge break for me if I can make it work.
Craig
Quick question - I have been working on a project in Visual Studio 2008 for the last year and using SQL Server Express 2008 as my database, but have really come to have a lot of grief trying to distribute it with my executable. I just learned today about LocalDB in SQL Server Express 2012, and it sounds like just what I need for this application. But I have read that I may have trouble trying to use it from VS 2008. That said, those reports seem to indicate that the problem is with trying to use embedded access methods like server browser from visual Studio.
My application has no embedded connections to SQL Server, just connects to it using the system.data.sqlclient namespace and passes the usual connection string info. Assuming this, and assuming I install SQL Server 2012 Express on my system, should I be able to use LocalDB as my data source? Will I need to use a different or updated namespace?
Thanks for any help with this you can provide. This might really be a huge break for me if I can make it work.
Craig