SQL Azure .NET Connection

  •        45

This is a demo application that shows how to connect with SQL Azure

http://sqlazurenet.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

Catfax - SQL to Azure via SQL-CLR and WCF


The catfax project is a demonstration of moving SQL data to and from the cloud using SQL CLR, Azure WCF and Azure Storage

Azure Service Manager


Azure Service Manager is an enterprise application which provides an subscriber-based API through WCF to allow clients to collect information on multiple Azure subscriptions, including hosted services, SQL Azure and storage services. It provides service, usage and billing data.

WingTipTickets - Azure SQL Database WingTipTickets demo and hands on lab


Welcome to the WingTipTickets demo and hands-on-lab project.These files comprise a hands-on-lab that demostrates a number of the Azure Data Platform services including, Azure SQL Database, Azure SQL Data Warehouse, Azure Document DB, Azure Data Factory, Power BI and Azure Search. WingTipTickets is based sample application used to selling concert tickets and uses this set of services. Installing this into you're own Azure subscription is a great way to learn about Azure and how you might build applications that consume, transform, and visualize data.

thor


Project Thor is a community drive project meant to provide people with an opportunity to get familiar with Microsoft's cloud platform by developing a real-world application. Technologies utilized include Windows Azure, SQL Azure, and Exchange Web Services.

Azure-MachineLearning-DataScience


This repository contains walkthroughs, templates and documentation related to Machine Learning & Data Science services and platforms on Azure. Services and platforms include Data Science Virtual Machine, Azure ML, HDInsight, Microsoft R Server, SQL-Server, Azure Data Lake etc.There are also materials from tutorials we have delivered at KDD, Strata etc., using the above services and platforms.



ContactMetroClient - Metro client accessing SQL Azure DB via Azure WCF Service


Metro client accessing SQL Azure DB via Azure WCF Service

GraphView - GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to efficiently manage graphs


GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to manage graphs. It connects to a SQL database locally or in the cloud, stores graph data in tables and queries graphs through a SQL-extended language. It is not an independent database, but a middleware that accepts graph operations and translates them to T-SQL executed in SQL Server or Azure SQL Database. As such, GraphView can be viewed as a special connector to SQL Server/Azure SQL Database. Developers will experience no differences than the default SQL connector provided by the .NET framework (i.e., SqlConnection), only except that this new connector accepts graph-oriented statements.GraphView is a DLL library through which you manage graph data in SQL Server (version 2008 and onward) and Azure SQL Database (v12 and onward). It provides features a standard graph database is expected to have. In addition, since GraphView relies on SQL databases, it inherits many features in the relational world that are often missing in native graph databases.

OData over SQL Azure Federations


This is a sample project that demonstrates how to expose an SQL Azure federated database throught the WCF DataService. Entity Freamework is used as a data access layer. Both EF code first (POCO) and database first approaches are represented.

SQL Azure Federation Data Migration Wizard


SQL Azure Federation Data Migration Wizard simplifies the process of migrating data from a single database to multiple federation members in SQL Azure Federation.

AzureUsageAndBillingPortal - This web application solution enables you to monitor the usage and billing for any Azure subscriptions you have access to


This project is designed to retrieve the usage details of all Azure services in a specific Azure subscription(s). Using PowerBI dashboard, one can retrieve up to date billing data (Azure service usage details) of a subscription that is registered to the system. First, any user with an active azure subscription has to register their subscription with the system through the registration website. To get registered, only the subscription owner's Microsoft ID (i.e. email address that ends with Hotmail.com, outlook.com etc.) or an organization ID (i.e. email address that ends with microsoft.com, fabrikam.com etc.) and subscription’s domain name is needed. Providing this data, a user can register their Azure subscription with the system. Once the subscription is registered, the system automatically retrieves the past 3 years (adjustable parameter) usage data and allows it to be viewed by a PowerBI dashboard. Additionally, every day at UTC 00:00 o’clock, the system automatically retrieves the previous day’s usage and billing data for each registered subscription in the system. By doing this, it keeps all records up to date on a daily basis. There is always a 1-day delay (currently you can’t retrieve the past few hours’ data immediately because the main Azure system collects all data from different datacenters within different time zones) on the data presented through PowerBI.The PowerBI dashboard allows users to filter data in realtime according to different parameters such as: Subscriptions, Services, SubServices, etc.

sql-xplat-cli - Repository for the new SQL cross-platform command line tools


We’re excited to introduce mssql-scripter, a multi-platform command line experience for scripting SQL Server databases.mssql-scripter is the multiplatform command line equivalent of the widely used Generate Scripts Wizard experience in SSMS. You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server running anywhere, Azure SQL Database, and Azure SQL Data Warehouse. You can save the generated T-SQL script to a .sql file or pipe it to standard nix utilities (for example, sed, awk, grep) for further transformations. You can edit the generated script or check it into source control and subsequently execute the script in your existing SQL database deployment processes and DevOps pipelines with standard multiplatform SQL command line tools such as sqlcmd.

WCF Data Service Format Extensions for CSV, TXT


This project add support for Legacy formats like CSV, TXT (CSV Export) to the data service output and allow $format=txt query. By default WCF Data Services support Atom and JSON responses however legacy systems do not understand ATOM or JSON but they understand CSV, TXT f...

Silverlight DataGridToolbar Control for OData, RIA Services and local data


The library contains three controls for Silverlight DataGrid. The first control works with OData(WCF Data Services), the second one works with RIA Services and the third one works with local data. It can be used to filter, remove, edit and insert data.

developer-immersion-data - Developer Immersion "Developing with Data"


Get hands-on and learn how to build secure, performant, scalable and predictive application modernization practice centered around data-driven intelligent apps (using SQL Server 2016 and Azure Database Services), and re-architect on-premises ISV/SaaS apps to Azure for scale, reach.

BCP2SQLAzure: Free tool to import/export data between SQL Azure and SQL Server


SQL Azure BCP makes it easier for database admins and developers, to do bulk copy loads into SQL Azure. This bcp replacement allows you to define each load using an easily XML file. It´s developed using C#.

SSDS Examples


This is a collection of examples using Microsoft;s SSDS Cloud database services. As of 2008-12-13 release, all code is updated and points to SQL Data Services CTP Public servers. These projects were built w/ .NET 2.0 C# on WinXP. No need for Vista, VS2008 or Azure SDKs.

cortana-intelligence-personalized-offers - Generate real-time personalized offers on a retail website to engage more closely with customers


In today’s highly competitive and connected environment, modern businesses can no longer survive with generic, static online content. Furthermore, marketing strategies using traditional tools are often expensive, hard to implement, and do not produce the desired return on investment. These systems often fail to take full advantage of the data collected to create a more personalized experience for the user. Surfacing offers that are customized for the user has become essential to build customer loyalty and remain profitable. On a retail website, customers desire intelligent systems which provide offers and content based on their unique interests and preferences. Today’s digital marketing teams can build this intelligence using the data generated from all types of user interactions. By analyzing massive amounts of data, marketers have the unique opportunity to deliver highly relevant and personalized offers to each user. However, building a reliable and scalable big data infrastructure, and developing sophisticated machine learning models that personalize to each user is not trivial.Cortana Intelligence provides advanced analytics tools through Microsoft Azure — data ingestion, data storage, data processing and advanced analytics components — all of the essential elements for building an demand forecasting for energy solution. This solution combines several Azure services to provide powerful advantages. Event Hubs collects real-time consumption data. Stream Analytics aggregates the streaming data and updates the data used in making personalized offers to the customer. Azure DocumentDB stores the customer, product and offer information. Azure Storage is used to manage the queues that simulate user interaction. Azure Functions are used as a coordinator for the user simulation and as the central portion of the solution for generating personalized offers. Azure Machine Learning implements and executes the product recommendations and when no user history is available Azure Redis Cache is used to provide pre-computed product recommendations for the customer. PowerBI visualizes the activity of the system with the data from DocumentDB.

Geolocalised Services


Website allowing customers to find services based on the maps and metadata provided by the providers. Customers will no longer need to use complicated, time consuming interfaces to find the services next to them Developed with Microsoft .NET, SQL Server and Windows Azure

Microsoft Dynamics CRM Query - T4 Template


In short, this project provides a LINQ style data access solution for Microsoft CRM 4.0. It provides a T4 Template that generates code leveraging LINQ to SQL and the MS-CRM 4.0 API to give a MS-CRM CRUD data access solution. Special Support for WCF RIA Services is also provided