Fluent Nhibernate and sql script

Question

I want to execute a script with variables in order to create a new database. At first, i tried with command line but i want to execute the script from another server but i have errors about access rights.

Is it possible to execute a SQL script with fluent nhibernate in the application code?

I've found an answer on that link but it doesn't execute the script, it loads queries.
link

Thanks for help.

Radim Köhler · Accepted Answer · 2015-04-02 04:53:48Z

2

JUST a note: Fluent NHibernate is just a third party library for mapping. To execute script you need just NHibernate.

And in fact, the answer you've found, is the answer. The point of WRITE scripts is to call ExecuteUpdate() at the end

var query = session.CreateSQLQuery("your sql to string with INSERT, UPDATE...");
// that will execute that all
query.ExecuteUpdate();

answered Apr 2, 2015 at 4:53

Radim Köhler

124k48 gold badges243 silver badges343 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Fluent Nhibernate and sql script

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related