// use ADO.NET to query all rows from server. Let assume we get all data the table in records
            Collection<RecordColumn> records = new Collection<RecordColumn>();
            Collection<DbfColumn> shapeFileColumns = new Collection<DbfColumn>();
            shapeFileColumns.Add(new DbfColumn("RecordID", DbfColumnType.Integer, 20, 6));
            shapeFileColumns.Add(new DbfColumn("Intensity", DbfColumnType.Float, 20, 6));
            ShapeFileFeatureSource.CreateShapeFile(ShapeFileType.Point, "E:/Test.shp", shapeFileColumns);


            ShapeFileFeatureSource shapefileFeatureSource = new ShapeFileFeatureSource("E:/Test.shp");
            shapefileFeatureSource.Open();
            shapefileFeatureSource.BeginTransaction();

            foreach (var record in records)
            {
                Dictionary<string, string> columnValues = new Dictionary<string, string>();
                columnValues.Add("Intensity", record.intensity.ToString());
                columnValues.Add("RecordID", record.id.ToString());
                Feature addingFeature = new Feature(new PointShape(double.Parse(record.lon), double.Parse(record.lat)), columnValues);
                shapefileFeatureSource.AddFeature(addingFeature);
            }

            shapefileFeatureSource.CommitTransaction();
            shapefileFeatureSource.Close();