Free ado.net software for windows

Requirements: Microsoft .NET Framework

System Requirements: .NET Framework

Enhancements: Integration with improved dbMonitor added Implemented DefaultCommandTimeout parameter in connection string (by default, set to 0) Added orderid column for Site Map provider for custom map node ordering Added some DataSet Wizard design-time improvements

EasyQuery.NET (WebForms) 2.4 is a free tool that lets your users to get the data they want without any assistance from the developer or site administrator. This outstanding solution allows to create queries to your database using friendly graphical interface which looks for end-user as just a statement in his(her) native language.

EasyQuery.NET library is a set of native .NET classes, components and controls that allows you to include end-user-oriented query builder into your ASP.NET web-site.

EasyQuery.NET WebForms fully supports ASP.NET AJAX (former ATLAS) components so you can get all power of AJAX technology with ad-hoc query building and reporting.

The most wonderful thing about EasyQuery.NET WebForms is that its demo version is totally FREE for using on any ASP.NET web-site! Demo version works exactly like full version of the product but shows a watermark on panel's background and contains a link to EasyQuery web page at the bottom of QueryPanel and QueryColumnsPanel controls.

Another good thing about EasyQuery.NET is that you do not need to install it to see how it works.

Major Features:

1. Natural language user interface for query building;
2. Programming language: C#;
3. Distributed as 100% pure .NET assemblies;
4. Supported .NET framework versions: 1.1 (only WinForms editions), 2.0, 3.5;
5. Supported databases: MS Access, MS SQL Server, Oracle, MySQL, PostgreSQL as well as any other database which can be used through ADO.NET;

• Added: An ability to define sorting columns separately from the main column list;
• Added: BuildParamSQL() method in Query class which allows to build parametrized SQL statements;
• Added: Params property in Query.Result give an access to list of parameters in case of using BuildParamSQL method;
• Added: AllowSorting property in QueryColumnsPanel control;
• Added: "Aggregate" property for virtual entity attributes;
• Added: Automatical generation of HAVING clause for conditions with entity attributes marked as "aggregate";
• Added: Now QueryColumnsPanel and SortColumnsPanel can show Up and Down buttons: see Appearance.ShowUpDownButtons property;
• Added: Appearance.ScriptMenuStyle.ItemMaxWidth property allows to specify maximum width of menu items. If some item is wider then it will be wrapped.
• Added: The top position of sub-menus is adjusted automatically according to the current window height.
• Added: An ability to specify class for 'over' menu items: Appearance.ScriptMenuStyle.CssClassOver property;
• Added: An ability to specify background color for 'over' menu items: Appearance.ScriptMenuStyle.BackColorOver property;
• Added: EditMode property in QueryPanel and QueryColumPanel controls: An ability to fix some panel elements;
• Added: ReadOnly property for Query.Condition objects;
• Changed: Appearance.ScriptMenuStule.ItemWidth property was renamed to ItemMinWidth;
• Fixed: The problem with unnecessary horizontal scroll bars in script menu.

DatAdmin Personal 3.0.5 is just a perfect choice for easily and quickly administrating database. It natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. Also it can be used to create and restore backups, transfer data between databases, tables or files (supported formats are XML, CSV, HTML, Excel), edit database schema.

Major Features:

1. Connect to database
   • Connect using ADO.NET native drivers. Distributed with native ADO.NET drivers for MySQL, PostgreSQL, Sqlite. Native drivers for MS SQL are distributed with .NET.
   • Function Driver manager, which allows using other ADO.NET drivers
   • Connection over generic database interfaces OLE DB and ODBC
   • Function PHP tunnel, which allows connection to MySQL databaases on webhosts server, which dosn't offer direct access to database server
2. Database management
   • Creating and editing tables (CREATE, ALTER TABLE), database specific table properties (MySQL engine, collation)
   • Comfortable foreign key management, UPDATE/DELETE rules
   • CHECK, UNIQUE constraints, indexes
   • Database object management - triggers, functions, stored procedures, views, schemata
   • Generating SQL scripts for different object types - CREATE, DROP
   • MySQL objects: triggers, functions, stored procedures, views, events
   • MS SQL objects: triggers, functions, stored procedures, views
   • SQLite objects: triggers, views
3. View and edit data
   • Viewing and editing data in table
   • Quick fulltext search
   • Filtering rows - fulltext search or SQL conditions
   • Sorting rows by clicking on column header, sorting by more columns
   • Lookups (preview of destination foreign key row), selecting rows from validation tables
   • Automatic master/detail views created from foreign keys
   • Forward/Back function for browsing master/detail views history
4. Backup, export, import
   • Backup database as "Data archive" - ZIP file - platform and database independent backup
   • Ability to use native backuping tools (mysqldump, pg_dump)
   • Restore from backup, restore whole database or selected tables (selecting tables is possible only when using data archive as backup format)
   • Export of table data to formats CSV, TXT, HTML, XML, SQL, Excel
   • Import of table from formats CSV, XML
   • Export database structure into formats HTML, WIKI
   • Copy database/table to another server using drag & drop
   • Any data operation can be saved as job and executed later, also from command line
   • Scheduling using Windows Scheduler Service (applicable to any type of job)
5. Database design
   • Editing of database model. Model can be generic or database specific
   • Definition of tables, keys, constraints
   • Definition of all object types in database model
   • Database diagrams, stored in connection (locally or in database)
   • Comparing & synchronize structure of model, real database or data archive (database backup)
   • Migration of model to different dialect
   • Generating CREATE/DROP scripts in any of supported dialect
   • Reverse engineering - loading model from existing database
6. SQL Editor
   • SQL Editor with syntax highlighting
   • Advanced search & replace
   • SavingSQL query to connection - locally or in database
   • Viewing more result sets from one query
   • Graphical query designer, with drag & dropping tables from connection tree, tables could be joined (LEFT/RIGHT/INNER/OUTER JOIN), sorting, filtering, grouping

Requirements:

• Windows 2000 Service Pack 3; Windows 98; Windows 98 Second Edition; Windows ME; Windows Server 2003; Windows XP Service Pack 2, Windows Vista. Since DatAdmin 3.1 both 32-bit and 64-bit versions are fully supported.
• Microsoft .NET framework 2.0