Free oledb software for windows

TierDeveloper .NET 6.1 is a powerful and easy-to-use tool that helps you develop real-life complex .NET database application in record times. TierDeveloper does this by letting you map objects to relational databases, put power SQL and business rules in them, and generate fully working code instantly. TierDeveloper also generates an ASP.NET application to either let you test the generated objects or to use as a powerful admin application.
Some of the main benefits of using TierDeveloper are:

• Speed up .NET Development: 50% of your code is generated instantly.
• Improve Code Quality: All generated code is consistent and based on a design pattern.
• Reduce Testing Effort: All generated code is based on pre-tested templates.

Major Features:

1. Object Mapping Features
   
   • Filtered Object Inheritance
   • Map stored procedures to objects
     
2. Objects
   
   • Map to a single table or multiple tables
   • Map to a view (read-only or in update mode)
   • Define unmapped objects and create tables for them automatically
   • Support for auto-generated keys (Identity keys and sequenced values)
   • Select subset of table-columns as object attributes
   • Support for formula (computed) fields in objects
   • Support for NULL values (IsNull and SetNull)
   • Name object attributes different from table-columns
   • Support all the data types in target language including BLOB
   • Data validation on attributes provided including range-checking, greater than, or less than checking
   • Extendible field validation framework. Add your own custom field validation logic
   • Required and optional field checking
   • Save an object only if it is "dirty" (meaning data is changed in it)
   • Serialization support for all objects
3. App GUI Designer Features (ASP.NET & Windows Forms)
   
   • App GUI Wizard (New)
   • Forms Designer
   • List Pages Designer
   • Ad Hoc Search Page Designer
   • Menu Designer
4. Transaction Support
   
   • Specify insert, update, delete, and single-row select operations
   • Specify multiple insert and single-row update operations
   • Specify bulk updates and deletes with custom where-clause
   • Specify transactional characteristics of objects for COM+
   • Full transaction support for non-COM+ components in a parent-child relationship
   • Non-COM+ components can also be part of client initiated transactions
   • Transaction isolation levels for each object
5. Queries
   
   • Query Timeout
   • Specify joins
   • Select subset of object attributes for retrieval
   • Specify custom where-clause with nested queries, UNIONs, and others
   • Accept run-time parameters
   • Return a collection of objects as the output of query
   • Support GetCount and GetPartialRows behavior in queries
   • Support SELECT DISTINCT on queries
   • Return Typed DataSets as query results
   • Automatically create queries based on indexes
6. Dynamic Queries: Same as normal queries but with following additional features:
   
   • Specify where-clause at run-time
   • Output of dynamic query is a collection of objects (just like normal queries)
7. Relationships:
   
   • Re-architected support for 1-1, 1-n, and m-n relationships
   • Added support for m-n relationships (thru a bridge table)
   • Parent-child relationships support for 1-1, 1-n, and m-n
   • Lazy loading of related objects in a relationships
   • Cascaded updates and deletes for all relationships provided
   • Automatically create relationships between objects
8. Parent/Child Relationships
   
   • In case of 1-1, 1-n, and m-n specify a parent-child characteristic
   • Parent object updates or deletes children as part of one transaction
   • Parent object loads all children
9. Stored Procedure Calls Relationships
   
   • Define methods in objects as calls to stored procedures
   • Specify input, input/output, and output parameters
   • Accept cursors as output of stored procedures
   • Use it when a stored procedure has complex business rules
   • Generate T-SQL stored procedures for all SQL used in objects
   • Generate CLR stored procedures for all SQL used in objects
   • TierDeveloper does this automatically and then generates objects code so it is calling these stored procedures
   • Improves performance
   • Use package syntax for generated Oracle stored procedures
10. Custom Hooks (safe code)
    
    • Write custom hooks to be called by the generated code from within the methods of objects
    • Custom hooks kept separate so objects code can be regenerated
    • Generate skeletons and a test application for custom code to make it easy for you to write custom code and test it independently
11. Typed Datasets
    
    • Support for Typed DataSets for all objects
    • Generate .xsd files for all objects and define relationships in them as well
12. NET Remoting Services
    
    • Select one of more objects and one or more methods in them and generate web services for them
    • Generates a Windows Forms remote client application
    • TierDeveloper support RPC-style web services
13. Code Generation
    
    • Support for Visual Studio 2008 and .Net Framework 3.0/3.5
      
    • Support for Microsoft Enterprise Library Security Application Block
      
    • Support for WCF
      
    • .NET Remoting App
    • Generate ASP.NET and Windows Forms application
    • Now you can generate code through TierDeveloper that supports .Net Nullable types
    • Complete re-architected template-based code generation engine
    • Code templates based on JavaScript language and are customizable
    • Customize names for classes, methods, and properties
    • Generate .NET components in C# and VB.NET
    • Generate either COM+ or non-GAC code
    • Generate updatable Datasets
    • Build .NET components as private or shared assemblies
14. WEB App Generation
    
    • Ajax Support
    • Generate a fully-working web application
    • Web app contains pages to test each and every object behavior
    • Generate web app with or without XML/XSLT
15. Schema Level View
    
    • Quickly view object mappings against all tables in the schema
    • Instantly view overlaps in objects on table-mapping
    • Easily see which tables haven't been mapped
    • Makes object design work very easy
16. SQL Query Tool
    
    • Quick compile and run SQL before committing it to objects
    • Invoke SQL Query Tool from query definition and stored procedure definition windows
    • Output of the SQL shown in a multi-column list in bottom window
17. Generate Design Docs
    
    • Generate meaningful design docs in HTML for generated objects
    • Easily update design docs whenever you change objects
    • 424Database Servers
    • Microsoft SQL Server 2000/2005/2008
      
    • Oracle 8i/9i/10g
    • IBM DB2 7.x, 8.1
    • MS Access 2000 or later
    • .NET code uses OleDb, SqlClient, and Oracle Client for database access
18. New TierDeveloper GUI
    
    • Completely redesigned GUI for TierDeveloper (consistent with VS.NET)
    • Stand-Alone and VS.NET integrated versions have identical GUIs
19. ASP.NET and Windows
    
    • FormsCompletely redesigned and easier-to-use GUI for generated ASP.NET app
    • Support for Windows Forms application generation with a nice GUI layout
    • Customize GUI layout for ASP.NET and Windows Forms apps
    • GUI layout customization from within VS.NET and/or XML file
    • Use drop-down controls with lookup values on forms
    • Re-arrange fields on the form, change their sizes, change labels, and more
    • Customize layout of list pages. Re-arrange column order, width, and titles
    • 1-1, 1-n, and m-n relationships supported in forms and lists
    • Support of partial classes
20. SQL Server Optimization
    
    • Generate SQL API based object code
    • Use Windows authentication for security
21. Oracle Optimization: Generate Oracle Native Data Provider based object code

Enhancements:

1. Support for Visual Studio 2008 and .Net Framework 3.0/3.5: If user opts to generate the code for .Net Framework 3.0/3.5, code is generated for Visual Studio 2008 for later versions.
   
2. Support for SQL Server 2008: Users will be able to connect to SQL Server 2008 databases.
   
3. Support for Microsoft Enterprise Library Security Application Block: Users can use Role-Based Authorization in their Factory methods. TierDeveloper uses Microsoft Enterprise Library Security Application Block along with Policy Injection block for security.
   
4. Support for WCF: Support for WCF is included in TierDeveloper 6.0. TierDeveloper generates:
   
   • WCF Business Services for components. (Class Library)
   • Host Application (Console)
   • Proxies for Services (Class Library)
5. Map stored procedures to objects: Map the output of a stored procedure call to an object. Then, when the stored procedure is called, it returns a collection of the mapped objects. This way, you can use objects for all your database interaction.
   
6. App GUI Wizard: Quickly specify the GUI of your application through an easy to use wizard. Wizard lets you select how many forms, list pages, ad hoc search pages you want and which objects they should be mapped to. It also lets you specify the menu of your application and a login page. Wizard then lets you generate either ASP.NET or Windows Forms application. This is the fastest way of generating a custom app GUI.