i was waiting for the video… i’m still downloaidng 🙂
thanks Steve

Steve,

fyi: you can delete all your tables/views at one shot, just do SHIFT + object and hit the delete

i see that you are deleting every single object one at a time… thought to share with you.

thanks.

Hi steve,
In your previous screen cast, you have a many to many relationship on the OrderProduct Table and you created a mapping file without a class. My question is how do you insert into the mapping table.

thanks

@Steve,

i did not realize that other tbls have FK sorry about that …my bad…. but one thing is that if your tbls having no FK then you can delete all at on shot by doing like this: click on the TABLE and on the right hand side you will see a SUMMARY window where you can select multiple objects and delete hit delete button … oh this technique you can apply for views/SP also.

please see my question #2

thanks

Hi Steve,
thanks for the great screen casts.

I just want to have some feedback regarding the column check.
I did test the column check using NHibernate 2.0 (the latest release… just yesterday) and guess what it worked just fine and it indeed generated the desirable DDL.

Cost REAL null check( Cost > 0) ,

thanks
Ali

Hi Steve, thanks for your ongoing great work! Truly enjoy every minute of your screen casts!

Boy, this “work around” for dealing with views is pretty whacked – hasn’t anyone on the NHibernate team every thought of introducing something like a “table-type” property on the tag, with values of “table” or “view” ?? Having to let NHibernate create a “wrong” table, then whacking it out again and having to write a SQL statement (which needs to be kept up and adapted every time I add a new field!) seems more like an awful hack than anything…….

C’mon – views ARE being used quite a bit in the database world – why can’t NHibernate support them in a better fashion? Has anything changed in the 2.0 code base in this regard?

I am sorry I forgot to paste the entire script. Here is the full SQL Script output.

***************************************************************************

Starting the MbUnit Test Execution
Exploring DataAccessTest, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
MbUnit 2.4.2.130 Addin
No tests found
alter table ProductOrder drop constraint FK_ProductOrders
alter table ProductOrder drop constraint FK_OrderProducts
alter table [Order] drop constraint FK_CustomerOrders
alter table viewCustomersWithYoyo drop constraint FKADD890B370C8035
alter table viewCustomersWithYoyo drop constraint FKADD890B313C3E8FD
alter table OrderProduct drop constraint FK_ProductOrders
alter table OrderProduct drop constraint FK_OrderProducts
if exists (select * from dbo.sysobjects where id = object_id(N’ProductOrder’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1) drop table ProductOrder
if exists (select * from dbo.sysobjects where id = object_id(N’Product’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1) drop table Product
if exists (select * from dbo.sysobjects where id = object_id(N'[Order]’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1) drop table [Order]
if exists (select * from dbo.sysobjects where id = object_id(N’viewCustomersWithYoyo’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1) drop table viewCustomersWithYoyo
if exists (select * from dbo.sysobjects where id = object_id(N’Customer’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1) drop table Customer
if exists (select * from dbo.sysobjects where id = object_id(N’OrderProduct’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1) drop table OrderProduct
create table ProductOrder (
Product INT not null,
[Order] INT not null
)
create table Product (
ProductId INT IDENTITY NOT NULL,
Name NVARCHAR(50) not null,
Cost REAL not null,
primary key (ProductId)
)
create table [Order] (
OrderId INT IDENTITY NOT NULL,
OrderDate DATETIME not null,
Customer INT not null,
primary key (OrderId)
)
create table viewCustomersWithYoyo (
CustomerId INT IDENTITY NOT NULL,
Firstname NVARCHAR(255) null,
Lastname NVARCHAR(255) null,
OrderId INT null,
OrderDate DATETIME null,
primary key (CustomerId)
)
create table Customer (
CustomerId INT IDENTITY NOT NULL,
Version INT not null,
Firstname NVARCHAR(50) null,
Lastname NVARCHAR(50) null,
primary key (CustomerId)
)
create table OrderProduct (
[Order] INT not null,
Product INT not null
)
alter table ProductOrder add constraint FK_ProductOrders foreign key (Product) references Product
alter table ProductOrder add constraint FK_OrderProducts foreign key ([Order]) references [Order]
alter table [Order] add constraint FK_CustomerOrders foreign key (Customer) references Customer
alter table viewCustomersWithYoyo add constraint FKADD890B370C8035 foreign key (CustomerId) references Customer
alter table viewCustomersWithYoyo add constraint FKADD890B313C3E8FD foreign key (OrderId) references [Order]
alter table OrderProduct add constraint FK_ProductOrders foreign key (Product) references Product
TestCase ‘M:DataAccessTest.NHibernateDataProviderTest.CreateDatebase’
failed: There is already an object named ‘FK_ProductOrders’ in the database.
Could not create constraint. See previous errors.
NHibernate.HibernateException: There is already an object named ‘FK_ProductOrders’ in the database.
Could not create constraint. See previous errors. —> System.Data.SqlClient.SqlException: There is already an object named ‘FK_ProductOrders’ in the database.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at NHibernate.Tool.hbm2ddl.SchemaExport.Execute(Boolean script, Boolean export, Boolean format, Boolean throwOnError, TextWriter exportOutput, IDbCommand statement, String sql)
at NHibernate.Tool.hbm2ddl.SchemaExport.Execute(Boolean script, Boolean export, Boolean justDrop, Boolean format, IDbConnection connection, TextWriter exportOutput)
at NHibernate.Tool.hbm2ddl.SchemaExport.Execute(Boolean script, Boolean export, Boolean justDrop, Boolean format)
— End of inner exception stack trace —
at NHibernate.Tool.hbm2ddl.SchemaExport.Execute(Boolean script, Boolean export, Boolean justDrop, Boolean format)
C:\Development\RnD\DineAndDiscussNHibernate_Session9\DataAccessTest\NHibernateDataProviderTest.cs(28,0): at DataAccessTest.NHibernateDataProviderTest.CreateDatebase()

0 passed, 1 failed, 0 skipped, took 2.25 seconds.

***************************************************************************

Thanks

I am trying to download the screen cast but this link always times out. Interestingly, I am able to download other sessions with .avi extension for example Session 06. Can anyone please guide me.

Hi Steve–I am using TestDriven.Net with MbUnit in a setup similar to yours. I tried using TestDriven.Net’s ability to run any arbitrary method in a class, but TD.N reports back that “NO TESTS WERE RUN (No tests found)”, and it doesn’t hit the method I have selected (verified with the “Test With… Debugger” option.

Any thoughts on why this may be happening, and what I can do to fix it? Thanks.

Full TestDriven.Net output:

—— Test started: Assembly: NHibernateRepository.Test.dll ——

Gallio TestDriven.Net Runner – Version 3.0.5 build 546

Test Assemblies:
C:\Users\David Veeneman\Documents\Visual Studio 2008\Projects\NHibernateRepository\NHibernateRepository.Test\bin\Debug\NHibernateRepository.Test.DLL

Start time: 5:39 PM
Verifying assembly names.
Initializing the test runner.
Loading the test package.
Exploring the tests.
Running the tests.
Unloading the test package.
Disposing the test runner.
Stop time: 5:39 PM (Total execution time: 2.093 seconds)

Test Report: file:///C:/Users/David%20Veeneman/AppData/Local/Temp/Gallio.TDNetRunner/NHibernateRepository.Test.DLL.html
** NO TESTS WERE RUN (No tests found) **

Steve,

Maybe you’ve addressed this elsewhere, but I noticed the following in the OrderProduct table.

In the .ddl file from the download for Session 1, a composite primary key is put on the Order and Product fields (as is usually the case with mapping tables).

The OrderProduct table finally generated in session 9 with SchemaExport has the foreign keys, but no primary keys.

To add this to OrderProduct, would we need to go ahead and create a mapping file for OrderProduct (and lose the genius of NHib)? Or add to one of the existing mapping files any manually add the composite primary key?

Thanks,

Jason

Of course I forget that posts strip html.

Second point should read …”to use ‘set’ instead of ‘bag'” (tags).

After fourth point, I had posted full xml of expanded tags for ‘key’ and ‘many-to-many’ for Order.hbm.xml. Basically, inside the ‘key’ and ‘many-to-many’ tags, put a ‘column’ self-closing tag with the column name and ‘not-null’.

TY

Jason

@Steve:

The check constraint only works if you define it at the class tab level:

0″>

Result:

create table Product (
ProductId INT IDENTITY NOT NULL,
Name NVARCHAR(50) not null,
Cost REAL not null,
primary key (ProductId),
check (Cost > 0)
)

Thanks for the screencast series,

AC

Steve,

A few questions and discoveries.

I am using 2.0.1GA on XP(SP3)

1) The Check constraint Count > 0 on the Cost column is working fine and generating this script:

create table Product (
ProductId INT IDENTITY NOT NULL,
Name NVARCHAR(50) not null,
Cost REAL null check( Cost > 0) ,
primary key (ProductId)
)

2) Mapped columns of type string are creating nvarchar fields. So the view filter of =’Yo-Yo’ gets converted to ‘N Yo-Yo’. All string columns get converted to nvarchar. Can this default be changed to varchar?

3) Creating the unique, unique-key and PK keys using schemaExport.Executegenerate keys with values ending in numbers like PK__Customer__09746778 and UC__Customer__0A688BB1. Can this naming be changed like the foreign-keys?

Thanks,
Mark