依然chsakell，他写了一篇前端AngularJS,后端OData,ASP.NET Web API的Demo,关于OData在ASP.NET Web API中的正删改查没有什么特别之处，但在前端调用API时，把各种调用使用$resouce封装在一个服务中的写法颇有借鉴意义。
文章：http://chsakell.com/2015/04/04/asp-net-web-api-feat-odata/
源码：https://github.com/chsakell/odatawebapi
首先是领域模型。
public class Employee { public int ID{get;set;} ... public int AddressID { get; set; } public virtual Address Address { get; set; } public int CompanyID { get; set; } public virtual Company Company { get; set; } } public class Address { public int ID{get;set;} ... } public class Company { public int ID{get;set;} .. public virtual List<Employee> Employees{get;set;} public Compay() { Employees = new List<Employee>(); } }
使用EF Fuent API对领域进行配置,继承EntityTypeConfiguration<T>,比如：
public class CompanyConfiguration: EntityTypeConfiguration<Company> { }
上下文继承DbContext。
public class EntitiesContext : DbContext { }
种子数据继承DropCreateDatabaseIfModelChanges.
public class EntitiesInitializer : DropCreateDatabaseIfModelChanges<EntitiesContext> { }
配置项目连接字符串。
<connectionStrings> <add name="EntitiesContext" providerName="System.Data.SqlClient" connectionString="Server=(localdb)v11.0; Database=CompanyDB; Trusted_Connection=true; MultipleActiveResultSets=true" /> </connectionStrings>
在项目全局文件中启用种子数据的配置。
protected void Application_Start() { GlobalConfiguration.Configure(WebApiConfig.Register); // Init the database Database.SetInitializer(new EntitiesInitializer()); }
在NuGet中输入odata,安装V4.0版本。
关于ODataController的增删改查，在"ASP.NET Web API基于OData的增删改查，以及处理实体间关系"比较详细的描述，这里略去，把重点放在前端的调用上。
先来看界面：
这里有个主视图，如下：
<html ng-app="mainApp"> <head> <link href="Content/styles/toastr.css" rel="stylesheet" /> <link href="Content/styles/loading-bar.css" rel="stylesheet" /> <script src="Content/scripts/jquery-2.1.1.js"></script> <script src="Content/scripts/bootstrap.js"></script> <script src="Content/scripts/angular.js"></script> <script src="Content/scripts/angular-resource.js"></script> <script src="Content/scripts/toastr.js"></script> <script src="Content/scripts/loading-bar.js"></script> <script src="Content/scripts/main.js"></script> <script src="app/services.js"></script> <script src="app/controllers.js"></script> </head> <body ng-controller="appCtrl" ng-init="getTop10Employees()"> <tbody ng-repeat="emp in employees"> <tr ng-click="setEmployee(emp)"> <td>{{emp.ID}}</td> <td>{{emp.FirstName}}</td> <td>{{emp.Surname}}</td> <td>{{emp.Email}}</td> </tr> </tbody> <!--更新或删除--> <form> <input type="text" id="id" ng-model="currentEmployee.ID" disabled> <input type="text" id="firstName" ng-model="currentEmployee.FirstName"> <input type="text"id="surname" ng-model="currentEmployee.Surname"> <input type="email" id="inputEmail" ng-model="currentEmployee.Email"> <input type="text" id="city" ng-model="currentEmployee.City" disabled> <input type="text" id="country" ng-model="currentEmployee.Country" disabled> <input type="text" id="state" ng-model="currentEmployee.State" disabled> <input type="text" id="company" ng-model="currentEmployee.Company" disabled> <button type="button" ng-click="updateEmployee()">Update</button> <button type="button" ng-click="deleteEmployee()">Delete</button> </form> <!--添加--> <form role="form"> <input type="text" name="firstname" ng-model="newEmployee.FirstName" /> <input type="text" name="surname" ng-model="newEmployee.Surname" /> <input type="text" name="email" ng-model="newEmployee.Email" /> <button type="button" ng-click="addEmployee()">Add</button> </form> <script type="text/javascript"> $(function () { toastr.options = { "positionClass": "toast-bottom-right", "preventDuplicates": true, "progressBar": true, "timeOut": "3000", } }); </script> </body> </html>
一般来说，前端针对某个领域的操作有多个，chsakell的一种写法特别值得推荐，那就是把针对某个领域的操作，在AngularJS中，用$resource封装到一个服务中去。如下：
angular.module('mainApp')
.factory('employeeService', function ($resource) {
var odataUrl = '/odata/Employees';
return $resource('', {},
{
'getAll': { method: 'GET', url: odataUrl },
'getTop10': { method: 'GET', url: odataUrl + '?$top=10' },
'create': { method: 'POST', url: odataUrl },
'patch': { method: 'PATCH', params: { key: '@key' }, url: odataUrl + '(:key)' },
'getEmployee': { method: 'GET', params: { key: '@key' }, url: odataUrl + '(:key)' },
'getEmployeeAdderss': { method: 'GET', params: { key: '@key' }, url: odataUrl + '(:key)' + '/Address' },
'getEmployeeCompany': { method: 'GET', params: { key: '@key' }, url: odataUrl + '(:key)' + '/Company' },
'deleteEmployee': { method: 'DELETE', params: { key: '@key' }, url: odataUrl + '(:key)' },
'addEmployee': { method: 'POST', url: odataUrl }
});
}).factory('notificationFactory', function () {
return {
success: function (text) {
toastr.success(text, "Success");
},
error: function (text) {
toastr.error(text, "Error");
}
};
})
然后针对Employee，在mainApp中增减一个controller用来针对Employee的各种操作。
angular.module('mainApp')
.controller('appCtrl', function ($scope, employeeService, notificationFactory) {
//存储当前用户
$scope.currentEmployee = {};
// Get Top 10 Employees
$scope.getTop10Employees = function () {
(new employeeService()).$getTop10()
.then(function (data) {
//存储所有用户
$scope.employees = data.value;
$scope.currentEmployee = $scope.employees[0];
//相当于设置Empoyee的导航属性
$scope.setCurrentEmployeeAddress();
$scope.setCurrentEmployeeCompany();
//通知
notificationFactory.success('Employeess loaded.');
});
};
// Set active employee for patch update
$scope.setEmployee = function (employee) {
$scope.currentEmployee = employee;
$scope.setCurrentEmployeeAddress();
$scope.setCurrentEmployeeCompany();
};
//设置当前Employee的地址
$scope.setCurrentEmployeeAddress = function () {
//获取当前Employee
var currentEmployee = $scope.currentEmployee;
return (new employeeService({
"ID": currentEmployee.ID,
})).$getEmployeeAdderss({ key: currentEmployee.ID })
.then(function (data) {
$scope.currentEmployee.City = data.City;
$scope.currentEmployee.Country = data.Country;
$scope.currentEmployee.State = data.State;
});
}
//设置当前Employee的Company
$scope.setCurrentEmployeeCompany = function () {
var currentEmployee = $scope.currentEmployee;
return (new employeeService({
"ID": currentEmployee.ID,
})).$getEmployeeCompany({ key: currentEmployee.ID })
.then(function (data) {
$scope.currentEmployee.Company = data.Name;
});
}
// Update Selected Employee
$scope.updateEmployee = function () {
var currentEmployee = $scope.currentEmployee;
console.log(currentEmployee.Email);
if (currentEmployee) {
return (new employeeService({
"ID": currentEmployee.ID,
"FirstName": currentEmployee.FirstName,
"Surname": currentEmployee.Surname,
"Email": currentEmployee.Email
})).$patch({ key: currentEmployee.ID })
.then(function (data) {
notificationFactory.success('Employee with ID ' + currentEmployee.ID + ' updated.')
});
}
}
$scope.deleteEmployee = function () {
var currentEmployee = $scope.currentEmployee;
return (new employeeService({
"ID": currentEmployee.ID,
})).$deleteEmployee({ key: currentEmployee.ID })
.then(function (data) {
notificationFactory.success('Employee with ID ' + currentEmployee.ID + ' removed.');
$scope.getTop10Employees();
});
}
$scope.addEmployee = function () {
var newEmployee = $scope.newEmployee;
return (new employeeService({
"FirstName": newEmployee.FirstName,
"Surname": newEmployee.Surname,
"Email": newEmployee.Email,
"AddressID": 1, // normally obtained from UI
"CompanyID": 3 // normally obtained from UI
})).$addEmployee()
.then(function (data) {
notificationFactory.success('Employee ' + newEmployee.FirstName + ' ' + newEmployee.Surname
+ ' added successfully');
$scope.newEmployee = {};
});
}
});