Discussion Forums

MsSql2008FeatureLayer[] layers = new MsSql2008FeatureLayer[100];
string conn = "Data Source=192.168.0.212;Initial Catalog=InternalDB;User ID=sa;Password=password";
for (int i = 0; i < 100; i++)
{
    layers[i] = new MsSql2008FeatureLayer(conn, "states", "recid");
    layers[i].Open();
    layers[i].ExecuteNonQuery("select * from states");
    layers[i].Close();
}

class MyMsSql2008FeatureLayer : MsSql2008FeatureLayer
    {
        public MyMsSql2008FeatureLayer()
            : this(string.Empty, string.Empty, string.Empty, 0)
        { }

        public MyMsSql2008FeatureLayer(string connection, string tableName, string featureIdColumn)
            : this(connection, tableName, featureIdColumn, 0)
        { }

        public MyMsSql2008FeatureLayer(string connection, string tableName, string featureIdColumn, int srid)
        {
            this.FeatureSource = new MyMsSql2008FeatureSource(connection, tableName, featureIdColumn, srid);
        }

        protected override void DrawCore(GeoCanvas canvas, Collection<SimpleCandidate> labelsInAllLayers)
        {
            this.Open();
            base.DrawCore(canvas, labelsInAllLayers);
            this.Close();
        }
    }

    class MyMsSql2008FeatureSource : MsSql2008FeatureSource
    {
        public MyMsSql2008FeatureSource()
            : this(string.Empty, string.Empty, string.Empty, 0)
        { }

        public MyMsSql2008FeatureSource(string connection, string tableName, string featureIdColumn)
            : this(connection, tableName, featureIdColumn, 0)
        { }

        public MyMsSql2008FeatureSource(string connection, string tableName, string featureIdColumn, int srid)
            : base(connection, tableName, featureIdColumn, srid)
        { }

        protected override RectangleShape GetBoundingBoxCore()
        {
            this.Open();
            RectangleShape boundingBox = base.GetBoundingBoxCore();
            this.Close();
            return boundingBox;
        }
    }


MyMsSql2008FeatureLayer sqlLayer = new MyMsSql2008FeatureLayer(connString, "*****", "*****", 3395);