Advanced using OData in .NET: WCF Data Services

Vincent-Philippe Lauzon

Rate me:

4.88/5 (26 votes)

16 Dec 2010Ms-PL9 min read

227.3K

6.2K

Samples showcasing usage of OData in .NET (WCF Data Services); samples go in increasing order of complexity, addressing more and more advanced scenarios.

OData.zip
- OData.Demo
  - AnotherDataModel
    - AnotherDataModel.csproj
    - DataModel.cs
    - ProcessDataService.svc
    - ProcessDataService.svc.cs
    - ProcessModel.cs
    - Properties
      - AssemblyInfo.cs
    - Web.config
    - Web.Debug.config
    - Web.Release.config
  - DataInsert.sql
  - ExposingTransformation
    - DataModel.cs
    - DemoModel.Designer.cs
    - DemoModel.edmx
    - DepartmentModel.cs
    - EmployeeDataService.svc
    - EmployeeDataService.svc.cs
    - EmployeeModel.cs
    - ExposingTransformation.csproj
    - Properties
      - AssemblyInfo.cs
    - Web.config
    - Web.Debug.config
    - Web.Release.config
  - HelloWorld
    - DemoModel.Designer.cs
    - DemoModel.edmx
    - EmployeeDataService.svc
    - EmployeeDataService.svc.cs
    - HelloWorld.csproj
    - Properties
      - AssemblyInfo.cs
    - Web.config
    - Web.Debug.config
    - Web.Release.config
  - OData.Demo.sln
  - OData.Demo.suo
  - SchemaCreation.sql
  - SchemaDrop.sql
  - ServiceOperations
    - DemoModel.Designer.cs
    - DemoModel.edmx
    - EmployeeDataService.svc
    - EmployeeDataService.svc.cs
    - Properties
      - AssemblyInfo.cs
    - ServiceOperations.csproj
    - Web.config
    - Web.Debug.config
    - Web.Release.config
  - TransformationClient
    - app.config
    - DataModelProxy.cs
    - Program.cs
    - Properties
      - AssemblyInfo.cs
    - TransformationClient.csproj
odata.zip
- AnotherDataModel.csproj
- DataModel.cs
- ProcessDataService.svc
- ProcessDataService.svc.cs
- ProcessModel.cs
- AssemblyInfo.cs
- Web.config
- Web.Debug.config
- Web.Release.config
- DataInsert.sql
- DataModel.cs
- DemoModel.Designer.cs
- DemoModel.edmx
- DepartmentModel.cs
- EmployeeDataService.svc
- EmployeeDataService.svc.cs
- EmployeeModel.cs
- ExposingTransformation.csproj
- AssemblyInfo.cs
- Web.config
- Web.Debug.config
- Web.Release.config
- DemoModel.Designer.cs
- DemoModel.edmx
- EmployeeDataService.svc
- EmployeeDataService.svc.cs
- HelloWorld.csproj
- AssemblyInfo.cs
- Web.config
- Web.Debug.config
- Web.Release.config
- OData.Demo.sln
- OData.Demo.suo
- SchemaCreation.sql
- SchemaDrop.sql
- DemoModel.Designer.cs
- DemoModel.edmx
- EmployeeDataService.svc
- EmployeeDataService.svc.cs
- AssemblyInfo.cs
- ServiceOperations.csproj
- Web.config
- Web.Debug.config
- Web.Release.config
- app.config
- DataModelProxy.cs
- Program.cs
- AssemblyInfo.cs
- TransformationClient.csproj


Microsoft Visual Studio Solution File, Format Version 11.00
# Visual Studio 2010
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "HelloWorld", "HelloWorld\HelloWorld.csproj", "{A47800A6-1A37-4C2B-8AC9-928CE4CD9EC6}"
EndProject
Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "DB Scripts", "DB Scripts", "{3F742592-6D40-40F9-8B82-742CE3881311}"
	ProjectSection(SolutionItems) = preProject
		DataInsert.sql = DataInsert.sql
		SchemaCreation.sql = SchemaCreation.sql
		SchemaDrop.sql = SchemaDrop.sql
	EndProjectSection
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "AnotherDataModel", "AnotherDataModel\AnotherDataModel.csproj", "{6A7DF766-6AB9-438F-80A0-1B8752AB9DAA}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ExposingTransformation", "ExposingTransformation\ExposingTransformation.csproj", "{4E205036-B8AC-4673-9250-563CC8813D62}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ServiceOperations", "ServiceOperations\ServiceOperations.csproj", "{7E78D66B-B5E4-4E32-B54E-6E0792BF685B}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "TransformationClient", "TransformationClient\TransformationClient.csproj", "{ADE3DE78-64D8-4468-B167-16975A9868A5}"
EndProject
Global
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
		Debug|Any CPU = Debug|Any CPU
		Debug|Mixed Platforms = Debug|Mixed Platforms
		Debug|x86 = Debug|x86
		Release|Any CPU = Release|Any CPU
		Release|Mixed Platforms = Release|Mixed Platforms
		Release|x86 = Release|x86
	EndGlobalSection
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
		{A47800A6-1A37-4C2B-8AC9-928CE4CD9EC6}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{A47800A6-1A37-4C2B-8AC9-928CE4CD9EC6}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{A47800A6-1A37-4C2B-8AC9-928CE4CD9EC6}.Debug|Mixed Platforms.ActiveCfg = Debug|Any CPU
		{A47800A6-1A37-4C2B-8AC9-928CE4CD9EC6}.Debug|Mixed Platforms.Build.0 = Debug|Any CPU
		{A47800A6-1A37-4C2B-8AC9-928CE4CD9EC6}.Debug|x86.ActiveCfg = Debug|Any CPU
		{A47800A6-1A37-4C2B-8AC9-928CE4CD9EC6}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{A47800A6-1A37-4C2B-8AC9-928CE4CD9EC6}.Release|Any CPU.Build.0 = Release|Any CPU
		{A47800A6-1A37-4C2B-8AC9-928CE4CD9EC6}.Release|Mixed Platforms.ActiveCfg = Release|Any CPU
		{A47800A6-1A37-4C2B-8AC9-928CE4CD9EC6}.Release|Mixed Platforms.Build.0 = Release|Any CPU
		{A47800A6-1A37-4C2B-8AC9-928CE4CD9EC6}.Release|x86.ActiveCfg = Release|Any CPU
		{6A7DF766-6AB9-438F-80A0-1B8752AB9DAA}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{6A7DF766-6AB9-438F-80A0-1B8752AB9DAA}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{6A7DF766-6AB9-438F-80A0-1B8752AB9DAA}.Debug|Mixed Platforms.ActiveCfg = Debug|Any CPU
		{6A7DF766-6AB9-438F-80A0-1B8752AB9DAA}.Debug|Mixed Platforms.Build.0 = Debug|Any CPU
		{6A7DF766-6AB9-438F-80A0-1B8752AB9DAA}.Debug|x86.ActiveCfg = Debug|Any CPU
		{6A7DF766-6AB9-438F-80A0-1B8752AB9DAA}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{6A7DF766-6AB9-438F-80A0-1B8752AB9DAA}.Release|Any CPU.Build.0 = Release|Any CPU
		{6A7DF766-6AB9-438F-80A0-1B8752AB9DAA}.Release|Mixed Platforms.ActiveCfg = Release|Any CPU
		{6A7DF766-6AB9-438F-80A0-1B8752AB9DAA}.Release|Mixed Platforms.Build.0 = Release|Any CPU
		{6A7DF766-6AB9-438F-80A0-1B8752AB9DAA}.Release|x86.ActiveCfg = Release|Any CPU
		{4E205036-B8AC-4673-9250-563CC8813D62}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{4E205036-B8AC-4673-9250-563CC8813D62}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{4E205036-B8AC-4673-9250-563CC8813D62}.Debug|Mixed Platforms.ActiveCfg = Debug|Any CPU
		{4E205036-B8AC-4673-9250-563CC8813D62}.Debug|Mixed Platforms.Build.0 = Debug|Any CPU
		{4E205036-B8AC-4673-9250-563CC8813D62}.Debug|x86.ActiveCfg = Debug|Any CPU
		{4E205036-B8AC-4673-9250-563CC8813D62}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{4E205036-B8AC-4673-9250-563CC8813D62}.Release|Any CPU.Build.0 = Release|Any CPU
		{4E205036-B8AC-4673-9250-563CC8813D62}.Release|Mixed Platforms.ActiveCfg = Release|Any CPU
		{4E205036-B8AC-4673-9250-563CC8813D62}.Release|Mixed Platforms.Build.0 = Release|Any CPU
		{4E205036-B8AC-4673-9250-563CC8813D62}.Release|x86.ActiveCfg = Release|Any CPU
		{7E78D66B-B5E4-4E32-B54E-6E0792BF685B}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{7E78D66B-B5E4-4E32-B54E-6E0792BF685B}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{7E78D66B-B5E4-4E32-B54E-6E0792BF685B}.Debug|Mixed Platforms.ActiveCfg = Debug|Any CPU
		{7E78D66B-B5E4-4E32-B54E-6E0792BF685B}.Debug|Mixed Platforms.Build.0 = Debug|Any CPU
		{7E78D66B-B5E4-4E32-B54E-6E0792BF685B}.Debug|x86.ActiveCfg = Debug|Any CPU
		{7E78D66B-B5E4-4E32-B54E-6E0792BF685B}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{7E78D66B-B5E4-4E32-B54E-6E0792BF685B}.Release|Any CPU.Build.0 = Release|Any CPU
		{7E78D66B-B5E4-4E32-B54E-6E0792BF685B}.Release|Mixed Platforms.ActiveCfg = Release|Any CPU
		{7E78D66B-B5E4-4E32-B54E-6E0792BF685B}.Release|Mixed Platforms.Build.0 = Release|Any CPU
		{7E78D66B-B5E4-4E32-B54E-6E0792BF685B}.Release|x86.ActiveCfg = Release|Any CPU
		{ADE3DE78-64D8-4468-B167-16975A9868A5}.Debug|Any CPU.ActiveCfg = Debug|x86
		{ADE3DE78-64D8-4468-B167-16975A9868A5}.Debug|Mixed Platforms.ActiveCfg = Debug|x86
		{ADE3DE78-64D8-4468-B167-16975A9868A5}.Debug|Mixed Platforms.Build.0 = Debug|x86
		{ADE3DE78-64D8-4468-B167-16975A9868A5}.Debug|x86.ActiveCfg = Debug|x86
		{ADE3DE78-64D8-4468-B167-16975A9868A5}.Debug|x86.Build.0 = Debug|x86
		{ADE3DE78-64D8-4468-B167-16975A9868A5}.Release|Any CPU.ActiveCfg = Release|x86
		{ADE3DE78-64D8-4468-B167-16975A9868A5}.Release|Mixed Platforms.ActiveCfg = Release|x86
		{ADE3DE78-64D8-4468-B167-16975A9868A5}.Release|Mixed Platforms.Build.0 = Release|x86
		{ADE3DE78-64D8-4468-B167-16975A9868A5}.Release|x86.ActiveCfg = Release|x86
		{ADE3DE78-64D8-4468-B167-16975A9868A5}.Release|x86.Build.0 = Release|x86
	EndGlobalSection
	GlobalSection(SolutionProperties) = preSolution
		HideSolutionNode = FALSE
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Microsoft Public License (Ms-PL)

Written By

Vincent-Philippe Lauzon

Architect CGI

Canada

Vincent-Philippe is a Senior Solution Architect working in Montreal (Quebec, Canada).

His main interests are Windows Azure, .NET Enterprise suite (e.g. SharePoint 2013, Biztalk Server 2010) & the new .NET 4.5 platforms.

Advanced using OData in .NET: WCF Data Services

License

Comments and Discussions