MongoIndexes.aspx前台代码
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="MongoIndexes.aspx.cs" Inherits="Web.MongoIndexes" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Mongodb索引</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="btnDefaultIndex" runat="server" Text="默认索引" OnClick="btnDefaultIndex_Click" />
<asp:Button ID="btnSingleIndex" runat="server" Text="单列索引" OnClick="btnSingleIndex_Click" />
<asp:Button ID="btnCombinationIndex" runat="server" Text="组合索引" OnClick="btnCombinationIndex_Click" />
<asp:Button ID="btnChildrenFileIndex" runat="server" Text="子文档索引" OnClick="btnChildrenFileIndex_Click" /><asp:Button
ID="btnOnlyIndex" runat="server" Text="唯一索引" OnClick="btnOnlyIndex_Click" />
<asp:Button ID="btnSelectIndex" runat="server" Text="查询所有索引名称" OnClick="btnSelectIndex_Click" />
<asp:Button ID="btnDelIndex" runat="server" Text="删除索引"
οnclick="btnDelIndex_Click" />
<asp:Button ID="btnDelAllIndex" runat="server" Text="删除所有索引"
οnclick="btnDelAllIndex_Click" />
</div>
</form>
</body>
</html>
MongoIndexes.aspx.cs后台代码
/// <summary>
/// 说明:Mongodb索引
/// 作者:田杰
/// 日期:2012-9-10
/// </summary>
public partial class MongoIndexes : System.Web.UI.Page
{
//链接字符串
public static string connectionString = "mongodb://localhost";
//数据库名
public static string databaseName = "myDatabase";
//集合名(相当于表)
public static string collectionName = "myCollection";
//定义Mongo服务
static Mongo mongo = new Mongo(connectionString);
//获取databaseName对应的数据库,不存在则自动创建
static MongoDatabase mongoDatabase = mongo.GetDatabase(databaseName) as MongoDatabase;
//获取collectionName对应的集合,不存在则自动创建
MongoCollection<Document> mongoCollection = mongoDatabase.GetCollection<Document>(collectionName) as MongoCollection<Document>;
protected void Page_Load(object sender, EventArgs e)
{
}
/// <summary>
/// 默认索引事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDefaultIndex_Click(object sender, EventArgs e)
{
DefaultIndex();
}
/// <summary>
/// 单列索引事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSingleIndex_Click(object sender, EventArgs e)
{
SingleIndex();
}
/// <summary>
/// 组合索引事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnCombinationIndex_Click(object sender, EventArgs e)
{
CombinationIndex();
}
/// <summary>
/// 子文档索引事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnChildrenFileIndex_Click(object sender, EventArgs e)
{
ChildrenFileIndex();
}
/// <summary>
/// 唯一索引事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOnlyIndex_Click(object sender, EventArgs e)
{
OnlyIndex();
}
/// <summary>
/// 遍历全部索引事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSelectIndex_Click(object sender, EventArgs e)
{
SelectIndex();
}
/// <summary>
/// 删除索引事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelIndex_Click(object sender, EventArgs e)
{
DelIndex();
}
/// <summary>
/// 删除所有索引事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelAllIndex_Click(object sender, EventArgs e)
{
DropAllIndex();
}
/// <summary>
/// MongoDB索引——》默认索引
/// 说明:MongoDB有个默认的“_id”的键,他相当于“主键”的角色。集合创建后系统会自动创建一个索引在“_id”键上,它是默认索引,索引名叫“_id_”,是无法被删除的。
/// </summary>
public void DefaultIndex()
{
//链接数据库
mongo.Connect();
try
{
var _idIndex = mongoCollection.Metadata.Indexes.Single(x => x.Key == "_id_");
Console.WriteLine(_idIndex);
MessageBox.Show(Page, "默认索引!");
}
finally
{
//关闭链接
mongo.Disconnect();
}
}
/// <summary>
/// MongoDB索引——》单列索引
/// 说明:在单个键上创建的索引就是单列索引,例如我们要在“UserInfo”集合上给“UserName”键创建一个单列索引,语法如下:(1表示正序,-1逆序)
/// </summary>
public void SingleIndex()
{
//链接数据库
mongo.Connect();
try
{
mongoCollection.Metadata.CreateIndex(new Document { { "UserName", 1 } }, false);
//接着,我们用同样方法查找名为“_UserName_”的索引
var _UserNameIndex = mongoCollection.Metadata.Indexes.Single(x => x.Key == "_UserName_");
Console.WriteLine(_UserNameIndex);
MessageBox.Show(Page, "单列索引!");
}
finally
{
//关闭链接
mongo.Disconnect();
}
}
/// <summary>
/// MongoDB索引——》组合索引
/// 说明:我们还可以同时对多个键创建组合索引。如下代码创建了按照“UserId”正序,“UserName”逆序的组合索引:
/// </summary>
public void CombinationIndex()
{
//链接数据库
mongo.Connect();
try
{
mongoCollection.Metadata.CreateIndex(new Document { { "UserId", 1 }, { "UserName", -1 } }, false);
var _Index = mongoCollection.Metadata.Indexes.Single(x => x.Key == "_UserName_");
Console.WriteLine(_Index);
MessageBox.Show(Page, "组合索引!");
}
finally
{
//关闭链接
mongo.Disconnect();
}
}
/// <summary>
/// MongoDB索引——》子文档索引
/// </summary>
public void ChildrenFileIndex()
{
//链接数据库
mongo.Connect();
try
{
//我们可以对文档类型的键创建各种索引,例如单列索引,如下创建用户详细信息“Detail”的单列索引:
mongoCollection.Metadata.CreateIndex(new Document { { "Detail", 1 } }, false);
//对子文档的键创建组合索引:例如在“Detail.Address”和“Detail.Age”上创建组合索引:
mongoCollection.Metadata.CreateIndex(new Document { { "Detail.Address", 1 }, { "Detail.Age", -1 } }, false);
MessageBox.Show(Page, "子文档索引!");
}
finally
{
//关闭链接
mongo.Disconnect();
}
}
/// <summary>
/// MongoDB索引——》唯一索引
/// 说明:唯一索引限制了对当前键添加值时,不能添加重复的信息。值得注意的是,当文档不存在指定键时,会被认为键值是“null”,所以“null”也会被认为是重复的,所以一般被作为唯一索引的键,最好都要有键值对。
/// 对“UserId”创建唯一索引(这时候最后一个参数为“true”):
/// </summary>
public void OnlyIndex()
{
//链接数据库
mongo.Connect();
try
{
mongoCollection.Metadata.CreateIndex(new Document { { "UserId", 1 } }, true);
var _Index = mongoCollection.Metadata.Indexes.Single(x => x.Key == "_UserId_");
Console.WriteLine(_Index);
MessageBox.Show(Page, "唯一索引!");
}
finally
{
//关闭链接
mongo.Disconnect();
}
}
/// <summary>
/// 遍历全部索引名称
/// 说明:集合的索引也是通过一个集合来维护的。name表示索引名,ns表示索引属于哪个库哪个集合,key表示索引在哪个键上,正序还是逆序,unique表示是否为唯一索引,等等...
/// </summary>
public void SelectIndex()
{
string str = "";
//链接数据库
mongo.Connect();
try
{
foreach (var index in mongoCollection.Metadata.Indexes)
{
Console.WriteLine(index.Value);
str += index.Value.ToString() + "%%";
}
MessageBox.Show(Page, str.ToString());
}
finally
{
//关闭链接
mongo.Disconnect();
}
}
/// <summary>
/// 删除索引
/// 说明:在MongoDB中不存在删除集合的说法,就算集合数据清空,索引都是还在的,要移除索引还需要手工删除。
/// </summary>
public void DelIndex()
{
//链接数据库
mongo.Connect();
try
{
mongoCollection.Metadata.DropIndex("_UserName_");
MessageBox.Show(Page, "删除索引!");
}
finally
{
//关闭链接
mongo.Disconnect();
}
}
/// <summary>
/// 删除除默认索引外其他全部索引的方法
/// </summary>
public void DropAllIndex()
{
//链接数据库
mongo.Connect();
try
{
var listIndexes = mongoCollection.Metadata.Indexes.ToList();
for (int i = 0; i < listIndexes.Count; i++)
{
if (listIndexes[i].Key != "_id_")
{
mongoCollection.Metadata.DropIndex(listIndexes[i].Key);
}
}
MessageBox.Show(Page, "删除除默认索引外其他全部索引的方法!");
}
finally
{
//关闭链接
mongo.Disconnect();
}
}
}