广州商城网站开发,佛山市做网站,建设安全协会网站,电信宽带做网站前两天在学习MongoDB相关的知识#xff0c;做了个小Demo#xff0c;做的是省份下面有多少所学校#xff0c;嗯#xff0c;做的比较粗暴。。。连接MongoDB首先要通过Nuget添加一个MongoDB的包#xff0c;下载此包安装完毕后开始写代码了#xff0c;创建一个省份实体#… 前两天在学习MongoDB相关的知识做了个小Demo做的是省份下面有多少所学校嗯做的比较粗暴。。。连接MongoDB首先要通过Nuget添加一个MongoDB的包下载此包安装完毕后开始写代码了创建一个省份实体一个学校实体using MongoDB.Bson.Serialization.Attributes;using System.Collections.Generic;namespace MongoCore.Models{ public class Province { [BsonId] public int ProvinceID { get; set; } public string ProvinceName { get; set; } /// summary /// 省份里有多个学校 这里用集合保存 /// /summary public IListSchool SchoolName { get; set; } }}namespace MongoCore.Models{ //用于后面添加学校 public School(string schoolName, string years) { SchoolName schoolName; Years years; } public class School { public string SchoolName { get; set; } public string Years { get; set; } }}创建上下文类连接MongoDBnamespace MongoCore.Models{ public class ProvinceContext { //定义数据库 private readonly IMongoDatabase _database null; public ProvinceContext() { //连接服务器名称 mongo的默认端口27017 var client new MongoClient(mongodb://.......:27017); if (client ! null) //连接数据库 _database client.GetDatabase(数据库名); } public IMongoCollectionProvince Province { get { return _database.GetCollectionProvince(Province); } } }}创建控制器private readonly ProvinceContext _context new ProvinceContext(); public async TaskIActionResult Index()
{ var list await _context.Province.Find(_ true).ToListAsync(); return View(list);
}视图model ListMongoCore.Models.Province{ ViewData[Title] Index;}h2Index/h2h2Index/h2a asp-actionCreateinput typebutton value新 建 classbtn btn-default //atable classtable tr th省份ID/th th省份名称/th th操作/th /tr foreach (var item in Model) { tr td Html.DisplayFor(modelItem item.ProvinceID) /td td Html.DisplayFor(modelItem item.ProvinceName) /td td a asp-actionInsert asp-route-ProvinceIDitem.ProvinceID新 增/anbsp;nbsp; a asp-actionDetail asp-route-ProvinceIDitem.ProvinceID详 情/anbsp;nbsp; a asp-actionDelete asp-route-ProvinceIDitem.ProvinceID删 除/anbsp;nbsp; /td /tr }/table运行的时候修改配置在Startup.cs里运行效果是这样的现在还没有数据点击新建按钮添加省份,这里我添加了湖北省添加省份代码如下后端public IActionResult Create() { return View(); } [HttpPost] [ValidateAntiForgeryToken] public async TaskActionResult Create(Province item) { try { //初始化学校类型数据 item.SchoolName new ListSchool(); await _context.Province.InsertOneAsync(item); return RedirectToAction(nameof(Index)); } catch { return View(); } }视图model MongoCore.Models.Province{ ViewData[Title] Create;}h2Create/h2div classrow div classcol-md-4 form asp-actionCreate div asp-validation-summaryModelOnly classtext-danger/div div classform-group label classcontrol-label省份ID/label input asp-forProvinceID classform-control / /div div classform-group label classcontrol-label省份名称/label input asp-forProvinceName classform-control / /div div classform-group input typesubmit value保 存 classbtn btn-default / /div /form /div/div接下来就是添加省份下面的学校了public async TaskIActionResult Insert(int ProvinceID) { var num await _context.Province.Find(p p.ProvinceID ProvinceID).SingleOrDefaultAsync(); return View(num); } [HttpPost] [ValidateAntiForgeryToken] public async TaskIActionResult Insert(int ProvinceID, string Years, string SchoolName) { var item await _context.Province.Find(p p.ProvinceID ProvinceID).SingleOrDefaultAsync(); School sl new School(SchoolName,Years); //添加学校 item.SchoolName.Add(sl); //更新 ReplaceOneResult actionResult await _context.Province .ReplaceOneAsync(n n.ProvinceID.Equals(ProvinceID) , item , new UpdateOptions { IsUpsert true }); return RedirectToAction(nameof(Index)); }视图model MongoCore.Models.Province{ ViewData[Title] Insert;}h2新增/h2div classrow div classcol-md-4 form asp-actionInsert div asp-validation-summaryModelOnly classtext-danger/div input typehidden asp-forProvinceID / div classform-group label classcontrol-label学校名称/label input nameSchoolName classform-control / /div div classform-group label classcontrol-label成立年份/label input nameYears classform-control / /div div classform-group input typesubmit value保 存 classbtn btn-default / /div /form /div/div然后添加学校我添加了两所学校在MongoDB里可以看到数据原文地址http://www.cnblogs.com/lcq529/p/8398004.html.NET社区新闻深度好文欢迎访问公众号文章汇总 http://www.csharpkit.com
