I am trying to use Data-Tier applications and am going through the tutorial here. When I get to step two the tutorial says to open Utility Explorer in the view menu. But it is not there! I looked all over the program for another entry point but I just dont see it. I am currently running SQL Server 2008 R2 Version 10.50.1352.12 and I a...
I'm trying to use a Data-Tier application involving a linked server and running into an odd problem. Here's what I have: 1) A VS2010 solution which includes a Data-Tier project. 2) The Data-Tier project targets an SQL 2008 R2 server. 3) The SQL server has a working linked server connection to an Oracle database. 4) Views within the ...
I am currently researching the best practises (at a reasonably high level) for application design for highly maintainable systems which result in minimal friction to change. By "Data Tier" I mean database design, Object Relation Mappers (ORMs) and general data access technologies. From your experiences, what have you found to be the com...
We are using the SQL Server Data-tier application and I'm having a hard time finding out what the current version a database is at. Is there a way to find it in SQL Server Management Studio Via an SQL statement From .net code ? Thanks Mark ...