DataSmith Features

Features of DataSmith
No	Description	See How
1	Connect/Query any datasource including flat files and Databases
2	Save connection info with name for reuse
3	For each connection, use different providers which will be auto-identified by DataSmith. This way you can get required performance of query output by choosing optimal provider
4	Add/Modify query parameters. Use native datatypes for parameters
5	Export query result to XLSX file. This feature does not require Microsoft Excel in your PC
6	View each cell value in query result using different UI control for different visualizations
Language Integrated Query
7	Provide static data source in connection string text box and write LInQ query against that data
8	Create Entity Data Model to your data source and write LInQ statements This will require associated data provider support. Most of the database vendors support LInQ in their providers. However you have to install them to use this feature.
9	Option to Export or Import Entity Object This way you can use a Entity DLL created in DataSmith to be used in Visual Studio and vice-versa
10	While creating the Entity model, provision to filter/search tables, views, procedures. This option is handy in databases where you have hundreds of tables, etc.
11	View each cell value in query result using different UI control for different visualizations
What next?
Release notes Install DataSmith
Free to use. Not free to distribute.