Okay... so, that means FileGDBAPI only operates within ArcGIS environment. If I want to make a connection between ArcGIS and SQL Server, and access the tables between the two, there's still no API for that.
I need to get the data from file geodatabases (feature datasets, raster catalogs, dbf files) into a format that our modeling application can use. However, before the models can use the data, we need to make all kinds of additional calculations, transformations (Some spatial, others not).
The data are huge (some have over a million rows). We use SQL Server 2008 to further manipulate these data. From SQL Server, we need to export the data again into a format that the model recognizes (but I'll get to that problem after I find a solution to the one at hand).
My problem is how to capture the data from an ArcGIS file geodatabase environment into a .NET environment. For example, at this point, in order for me to upload a dbf file into SQL Server, I convert the dbf table into an XML file and do a bulk insert into a SQL Server table that has the same schema as the dbf table. But this requires that I first create the destination table in SQL Server. What I need is some kind of a data provider that would allow me to simply create a connection to the datasets stored in file geodatabase and upload the attribute tables into SQL Server. This means, the provider should let me connect to the attribute table of a shapefile or feature datasets, raster catalogs, and yes, info or dbf tables.
I still don't know why I'm getting the error that it can't find the Esri.FileGDBAPI module.