Build Big-Data Apps: Listing 1.

Connecting to the Federation Root Database

/ Create a Connection to the Federation Root
SqlGuid fedKeyValue = customerId;
SqlConnection connection = 
  new SqlConnection(@"Server=tcp:sqlAzureURI;
  Database=SalesDB;User [email protected];
  Password=mypassword")
connection.Open();

// Route to the Specific Customer's Atomic Units
SqlCommand command = connection.CreateCommand())
command.CommandText = 
  "USE FEDERATION Orders_Federation(" +
  fedKeyValue.ToString() + ") WITH RESET";
command.ExecuteNonQuery();

About the Author

Roger Jennings is an independent XML Web services and database developer and writer. His latest books include "Special Edition Using Microsoft Office Access 2007" (QUE Books, 2007) and "Expert One-on-One Visual Basic 2005 Database Programming" (WROX/Wiley, 2005). He’s also a VSM contributing editor and online columnist and manages the OakLeaf Systems blog. Jennings’ Code of Federal Regulations Web services won Microsoft’s 2002 .NET Best Horizontal Solution Award. Reach him at [email protected].

comments powered by Disqus

Featured

  • Multi-Class Classification Using PyTorch: Model Accuracy

    Dr. James McCaffrey of Microsoft Research continues his four-part series on multi-class classification, designed to predict a value that can be one of three or more possible discrete values, by explaining model accuracy.

  • Python in VS Code Adds Data Viewer for Debugging

    The January 2021 update to the Python Extension for Visual Studio Code is out with a short list of new features headed by a data viewer used while debugging.

  • GitHub Ships Enterprise Server 3.0 Release Candidate

    It's described as "the biggest ever change to Enterprise Server," with improvements to Actions, Packages, mobile, security and more.

  • Attacks on .NET Apps Grow in Number, Severity, Says Security Firm

    .NET apps were found to have more serious vulnerabilities and suffer more attacks last year, according to data gathered by Contrast Labs.

Upcoming Events