[New]

Writing F# Type Providers with the F# 3.0 Developer Preview - An Introductory Guide and Samples

(Type provider code is upgraded to Beta) 

the download section has two files, one is for preview version which will be supported for another 3 months and the latest one is for beta release.

F# 3.0 Type Providers and Query

LINQ Query: 

• where - Simple 
• where - Indexed 
• distinct - Simple 
• Union - Simple 
• Intersect - Simple 
• Except - Simple 
• select - Simple 
• select - Transformation 
• select - Record Types 1 
• select - Record Types 2 
• select - Filtered 
• select - Compound
• exists - Simple 
• all - simple 
• take - simple 
• skip - simple 
• takeWhile - simple 
• skipWhile - simple 
• sortBy - Simple 1 
• sortBy - Simple 2 
• sortByDescending - Simple 
• thenBy - Simple 
• groupValBy - Simple 1 
• groupValBy - Simple 2 
• head - Condition 
• headOrDefault - Simple 
• nth 
• count - Simple 
• count - Conditional 
• sumBy - Simple 
• sumBy - Projection 
• minBy - simple 
• minBy - Projection 
• maxBy - Simple 
• maxBy - Projection 
• averageBy - Simple 
• averageBy - Projection
• Concat - Simple 
• SequenceEqual - Simple

SQL DataProvider:

• Using the type provider sample 
• TypeProvider query IN case 
• TypeProvider query EXISTS case 
• TypeProvider query GroupBy case 
• TypeProvider query GroupBy and OrderBy DESC case 
• TypeProvider query TOP case 
• TypeProvider query LEFT JOIN case 
• TypeProvider query COUNT case 
• TypeProvider query DISTINCT case 
• TypeProvider query DISTINCT COUNT case 
• TypeProvider query TOP and Nullable case 
• TypeProvider query UNION case 
• TypeProvider query CASE 
• Having and groupby 
• Cartesian product 
• TypeProvider average 
• TypeProvider sum 
• TypeProvider min/max

OData Service Provider and Azure Data market:

• Use the OData service to access Azure data market data source 
• Northwind public OData Service
• Lawyers.com - Consumer Legal Articles 
• MarketBank - Retail Financial Services Demand & Potential 
• BranchInfo - U.S. Bank Branch Locations, History & Performance Database 
• Data.Gov - 2006-2008 Crime in the United States (Data.gov) 
• ESRI - 2010 Key US Demographics by ZIP Code, Place and County (Trial) 
• LexisNexis - Legal Communities 
• Chanjet - China Small & Medium Enterprises Management & Operation KPI Data
• MetricMash - U.S. Consumer Price Index (1913 to Current) 
• EDR - Environmental Hazard Rank 
• MetricMash - U.S. Unemployment Data 
• Microsoft - Utility Rate Service

Other Providers:

• DBML Provider 
• DBML Provider - Console.Out as output 
• EDMX Provider 
• WsdlService - w3cschools temperature conversion 
• WsdlService - Bing Map rounting service

Basic

Arithmetic

• Integer Arithmetic 
• Floating Point Arithmetic 
• Converting between numeric types

Types and Functions

• Basic type and printf 
• Declaring and calling inner functions 
• Declaring and calling anonymous function lamda expressions
• Declaring a simple recursive function
• Function with type contraints 
• Using the Set type 
• Using the Map type 
• typeof operator 
• typedefof operator 
• Using interfaces 
• Upcast and downcast 
• Generic Type
• Mutual Definitions
• Define function
• Create disposal function

Loops

• For Loops 
• While Loops 

Enum, Struct, and Class

• Enumerations 
• Structs 
• Constructing Classes 
• Classes with methods and properties 
• define class 
• Define a class with mutable variable

Others

• Use function keyword 
• Basic Use Bindings 
• Read Two Lines, .NET-style 
• Read Entire File, .NET-style 
• Read Entire CSV File, .NET-style 
• Bitwise Integer Operations

Exceptions

• Raising a 'Failure' exception 
• Raising and catching a 'Failure' exception 
• Using KeyNotFoundException and exception patterns 
• Using ArgumentException and exception patterns

Array and Sequence:

• Basic Array Construction 
• Basic Array Construction 2 
• Using arrays 
• Using System.Collections.Generic.Dictionary 
• Using Tuples 
• Tuple to list 
• List to Tuple
• Basic Construction
• Basic List Construction 
• Basic List Construction 2 
• Lists and Pattern Matching 
• Lists and 'map' 
• Lists and Iteration 
• Lists and Indexed Iteration 
• Lists and Folding 
• Lists and Filter 
• Lists and Choose
• Basic Iteration 
• Using .iter 
• Using .map 
• Using .reduce 
• Using .filter 
• Using .choose 

Options, Union, and Record

• Simple options 
• Using options for data 
• Using Structural Equality 
• Using Structural Hashing 
• Basic Discriminated Unions 
• Discriminated Unions as Trees 
• Basic Records
• More Basic Records 
• Records with Members
• Define a mutable record

Operators:

• Define operator - inline function 
• Define prefix operator 
• Define operator 

Intermediate

Quotation:

• Use quotation 
• Use quotation to get function name and parameters

Interop and Office Interop

• Invoke win32 API 
• Call .NET functions
• Excel 
• Excel Chart 
• Word
• Use List 
• Parse number and handle out parameter in C#

Extension Methods

• Define extension methods 
• Define C# extension method

Others:

• Infinite sequence 
• Lazily Enumerate CSV File
• Define event 
• Aggreate type and LanguagePrimitives 
• Use structure format display attribute 
• Use structure format display complex structure 
• Use mail box processor to process simple message 
• Use mail box processor and isolation

Units of Measure

• Define units of measure 
• convert units of measure to float 
• convert units of measure and LanguagePrimitives

 Computation Expression

• Computation Expression sample

Object Expression

• WPF command implementation with object expression

Advanced and Others

Design Patterns:

• Composite pattern 
• Composite pattern with variable 
• Composite pattern with variable in a class 
• Composite pattern with variable in a class-like structure
• Composite pattern & continuation 
• Command pattern 
• Singleton pattern 
• Factory pattern 
• State pattern 
• Strategy pattern 
• Proxy pattern 
• Adapter pattern 
• Chain of responsibility pattern 
• Decorate pattern 
• Observer pattern
• Template pattern

Cloud:

• Azure Service bus sample code
• Azure Hello World sample code
• Azure MVC3 Web app sample code
• Azure WCF Service sample code

Active Pattern:

• Active pattern 
• Partial patterns 
• Active pattern with arguments 
• Active pattern: NULL

Others:

• Varaible name with space 
• Keyword as variable name 
• Serialization and Deserialization 
• Bank account
• Bank account and access control 
• Thread 
• Async 
• TPL 
• MSTest
• Write a unit Test

Portable:

• Spreadsheet sample

Prerequisites and Machine Setup 

This sample package requires Visual Studio 11 Developer Beta from MSDN.

SQL Server (Optional)

Because the SQL sample requires the local database to be setup. You need to set up a local SQL database named FSharpSample with sa password = FSharpSample1234. You can use CreateFSharpSampleDatabase.sql or setup.exe to setup your database tables and populate sample data. If you decide not to setup the database, some of the samples won't be compiled into the final binary result.

If you see a security dialog about trusting type provider, please click "Yes" to trust the type provider in order to make the sample run correctly.

Web Service Access (Optional)

You need to sign up for a free account on https://datamarket.azure.com/account/info and https://www.bingmapsportal.com/application/index/1034110 if you intend to run the web service samples. After you sign up on both web sites, you can replace the ADM user ID, ADM account ID, and Bing developer account information at the end of Support.Helper.fs.

Office Setup (Optional)

In order to run the office interop samples, you need to setup Word and Excel 2010 on your computer.