C#打开SDE数据库的几种方式总结-阿里云开发者社区

C#打开SDE数据库的几种方式总结

2017-11-14 1328

版权

本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

简介：

转自谢灿软件原文 C#打开SDE数据库的几种方式总结

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, 0);  
    }

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, 0);  
}

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, 0);  
    }