C#打开SDE数据库的几种方式总结
2024-10-01 14:00:48
1.通过指定连接属性参数打开数据库
/// <param name="server">数据库服务器名</param>
/// <param name="instance">SDE的端口,默认安装时"port:5151"</param>
/// <param name="user">SDE的用户名</param>
/// <param name="password">密码</param>
/// <param name="database">数据库的名字</param>
/// <param name="version">SDE的版本</param>
/// <returns></returns>
public IWorkspace OpenSdeWorkspaceByPropertySet(string server, string instance, string user, string password, string database, string version)
{
IPropertySet Propset = new PropertySetClass();
Propset.SetProperty("SERVER", server);
Propset.SetProperty("INSTANCE", instance);
Propset.SetProperty("USER", user);
Propset.SetProperty("PASSWORD", password);
Propset.SetProperty("DATABASE", password);
Propset.SetProperty("VERSION", version); IWorkspaceFactory workspaceFactory = new SdeWorkspaceFactoryClass();
return workspaceFactory.Open(Propset, );
}
2.通过连接字符串打开数据库
/// <param name="connectionString">连接字符串</param>
/// For example, "SERVER=Kona;DATABASE=sde;INSTANCE=5151;USER=Editor;PASSWORD=Editor;VERSION=sde.DEFAULT"
/// <returns></returns>
public IWorkspace OpenSdeWorkspaceByConnectionString(string connectionString)
{
IWorkspaceFactory2 workspaceFactory = new SdeWorkspaceFactoryClass();
return workspaceFactory.OpenFromString(connectionString, );
}
3.通过sde文件打开数据库
/// <param name="connectionFile">sde文件</param>
/// For example, "C:\\Data.sde"
/// <returns></returns>
public IWorkspace OpenSdeWorkspaceFromFile(string connectionFile)
{
IWorkspaceFactory workspaceFactory = new SdeWorkspaceFactoryClass();
return workspaceFactory.OpenFromFile(connectionFile, );
}
最新文章
- 剑指Offer面试题:23.二叉树中和为某一值的路径
- POJ 2480 (约数+欧拉函数)
- Linux crontab 命令详解
- friend class
- 使用3D物体做GUI界面
- Apache 支持PHP
- SPOJ PGCD (mobius反演 + 分块)
- iOS导航条渐变透明
- Webpack的加载器
- Page_Load不要忘了if (!IsPostBack)
- 动态规划——Palindrome Partitioning II
- patch 请求时,关于id的报错问题
- mysql并发更新
- 基于Keepalived的MySQL高可用
- [C#] VS2017中在某些目录下使用不了 .NET Core 2.0 问题的处理办法
- 【做题】TCSRM601 Div1 500 WinterAndSnowmen——按位考虑&;dp
- PetaPoco源代码学习--0.目录贴
- python+requests实现接口测试 - cookies的使用 (转载)
- 前端常见算法面试题之 - 二维数组中的查找[JavaScript解法]
- 在linux中添加环境变量