SSW Update - Do you make sure that the database structure is automatically handled via 3 buttons "Create", "Upgrade" and "Reconcile"?
Microsoft Gold Partner Logo

 

[ the cutting edge ]

G'Day Developers!

You get an error message reported from a user like:

When I click the Save button on the product form it gives an error message about a missing field.

You try and reproduce it on your version in the office and everything works perfectly, you suspect that the customer probably has changed the schema. So you start drafting an email to the user like:

Mary, I need you to send me your database schema as it might be different from what it should be. Can you:
  1. Open up Enterprise Manager (or SQL Management Studio)
  2. Open the first tree
  3. Open the second tree
  4. Select your server
  5. Open that tree
  6. Select Databases
  7. Open that tree
  8. Select the database called Northwind
  9. Right click on it and choose All Tasks, then Generate SQL Script
  10. Then select the options
  11. etc
  12. Then when I get this I will compare and I will make a script file for you to run and fix the problem

STOP! STOP! STOP!
It would be much better to just say:

Mary, click the "Reconcile" button and it will tell us what is wrong

Bottom line is the customers' database schema should always be correct and this should be managed automatically by the application.

Reconcile

Therefore, we always deliver an application with the buttons "Create", Upgrade" and "Reconcile", accessible via "Tools - Options" and a "Database" tab. We do this by using SSW SQL Deploy and throwing on the inherited user-control from the SSW.SQLDeploy.Options project.

See this and other hints on Rules to Better .NET Projects.

Cheers until next time, Adam
SSW Chief Architect and Microsoft Regional Director, Australia 

Got a comment for Adam? 6164616d636f67616e407373772e636f6d2e6175

Sydney .NET User Group -
The best place to learn .NET for free in Sydney

User Group

2 days to go!

Sydney .NET User Group
Wednesday 18th June 2008
5:45pm - 9:00pm
Microsoft, Sydney
1 Epping Road, North Ryde

Do you want a connection with that? (An introduction to building applications that don’t rely on a network connection) by Nick Randolph

Most developers have this obsession with building applications that connect directly to a database. Whether they be a web application or a rich client application, connecting directly or via a web service, the reality is that these applications need to be served with a reliable connection. Using some of the latest additions to the .NET Framework this session will walk you through building applications that will continue to work long after your connection drops out. You’ll see how easily the ADO.NET Synchronisation Services can be configured to establish a local cache for your data and how the Client Application Services will help you extend your existing security infrastructure to include your occasionally connected application.

‘LINQ to SQL’ vs ‘LINQ to Entities’ by Adam Cogan

Come hear Adam Cogan demonstrate Visual Studio 2008 using LINQ to SQL and LINQ to Entities.

LINQ is the future of ORM on the .NET platform and, with the release of Visual Studio 2008, we have a new way of working with databases. In this presentation you will learn about the different types of LINQ and how to use LINQ to quickly build data-driven applications. Adam will present on LINQ to SQL and LINQ to Entities showing the advantages and disadvantages of using in your .NET applications. You will also see how the LINQ syntax can easily make your queries more manageable and strongly typed for compile time checking.

See You There!!!| Sorry I can't make it

facebook See the new facebook group for the latest news.

Featured Product: SSW Exchange Reporter

SSW Exchange ReporterView reports on email usage for your Exchange Server users with SSW Exchange Reporter.

Is Microsoft Exchange Server an integral part of your organization? If so, SSW Exchange Reporter provides the tools and reports you need to efficiently analyze your organizations email usage. Built in Exchange reports range from who is sending the most emails, to who has the largest mailbox.
As new emails are sent and received, to and from your exchange server, our lightweight windows service seamlessly extracts email messages and folder statistics to your fast SQL Server backend. By taking advantage of SQL Servers Reporting Services, the generated reports can easily be customized and extended while being viewed securely from anywhere. That is why experts say that SSW Exchange Reporter is the most powerful and the only flexible solution to understanding your organizations communications.

More on SSW's Exchange Reporter

Advertise with SSW

If you would like to advertise your product or service with SSW or would like to find out more about various advertising opportunities, please email your enquiry to 736f7068696562656c6c65407373772e636f6d2e6175
or call: +61 2 9953 3000.

Proudly developed by SSW Sydney Web Design