Scripting the database
by Jason Dentler, Alexander Zaytsev, Gunnar Liljas
NHibernate 4.x Cookbook - Second Edition
- NHibernate 4.x Cookbook Second Edition
- Table of Contents
- NHibernate 4.x Cookbook Second Edition
- Credits
- About the Authors
- About the Reviewer
- www.PacktPub.com
- Customer Feedback
- Preface
- 1. The Configuration and Schema
- Introduction
- Installing NHibernate
- Configuring NHibernate with hibernate.cfg.xml
- Configuring NHibernate with App.config or Web.config
- Configuring NHibernate with code
- Configuring NHibernate with Fluent NHibernate
- Configuring NHibernate logging
- Generating the database
- Scripting the database
- Updating the database
- Using NHibernate schema tool
- 2. Models and Mappings
- Mapping a class with XML
- Creating class hierarchy mappings
- Creating class components
- Mapping a one-to-many relationship
- Mapping a many-to-many relationship
- Mapping collections of elements and components
- Setting up a base entity class
- Handling versioning and concurrency
- Mapping by code
- Mapping by convention
- Creating mappings fluently
- Bidirectional one-to-many class relationships
- Mapping enumerations
- Immutable entities
- Mapping relations to non-primary keys
- Using lazy properties
- Mapping joins
- Using calculated properties
- Using serializable values
- Dynamic components
- Mapping <subselect>
- 3. Sessions and Transactions
- Introduction
- Setting up session-per-web request
- Setting up session-per-presenter
- Creating a session ASP.NET MVC action filter
- Creating a transaction ASP.NET MVC action filter
- Save entities to the database
- Using session.Merge
- Using session.Refresh
- Handle concurrency using session.Lock
- There's more…
- Using dictionaries as entities
- Using NHibernate with transaction scope
- 4. Queries
- Introduction
- Query entities by ID
- Using LINQ to NHibernate
- Using CriteriaQueries
- Using QueryOver
- Using QueryOver projections and aggregates
- Using the Hibernate Query Language
- Using native SQL
- Eager loading with LINQ
- Eager loading with Criteria
- Eager loading with QueryOver
- Eager loading with HQL
- Eager loading with SQL
- Using named queries
- Using detached queries
- Using HQL for bulk data changes
- Filtering collections
- Using result transformers
- Extra lazy collections
- 5. Improving Performance
- 6. Testing
- 7. Data Access Layer
- 8. Extending NHibernate
- Introduction
- Creating an encrypted string type
- Creating a money type
- Using well-known instance types
- Using dependency injection with entities
- Creating an audit-event listener
- Creation and change stamping of entities
- Generating trigger-based auditing
- Implementing a soft-delete pattern
- Setting Microsoft SQL's Context_Info
- Using dynamic connection strings
- Using custom dialect functions
- Using custom functions in LINQ
- Extending the LINQ provider
- 9. NHibernate Contribution Projects
- Index
It's usually not appropriate for your application to recreate database tables each time it runs. In this recipe, we'll generate a SQL script to create your database objects.
Complete the Configuring NHibernate with App.config or Web.config recipe at the beginning of this chapter.
- Open
Program.cs. - Add these
usingstatements to the beginning of the file:using Eg.Core; using NHibernate.Mapping.ByCode; using NHibernate.Tool.hbm2ddl;
- Modify the
Mainmethod to look similar to this:var nhConfig = new Configuration().Configure(); var mapper = new ConventionModelMapper(); nhConfig.AddMapping(mapper.CompileMappingFor(new[] { typeof(TestClass) })); var schemaExport = new SchemaExport(nhConfig); schemaExport .SetOutputFile(@"db.sql") .Execute(false, false, false); Console.WriteLine("An sql file has been generated at {0}", Path.GetFullPath("db.sql")); Console.ReadKey(); - Build and run your application.
- Inspect the newly created
db.sqlfile.
Using the mapping metadata from the configuration object and the current dialect, hbm2ddl builds a SQL script for your entities.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.