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 ObjectThis 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.