Subsonic 3.0 how to correctly close connection

subsonicsubsonic3

I'm using Subsonic 3.0.0.3 Active Directory.
During program work, opens many connections to MySQL data base. I can see this threads in MySQL Administrator.
I'm working with data base in this case:

var db = new DB();
var nClient = Enumerable.First(db.clients, c => c.id_client == cl.ID);
nClient.data = data;
nClient.Update();

another example

var nClient = new client { data= cl.data };
nClient.Save();

How should I correctly close connection to database? Or how to use only one connection to database?

Best Answer

It will close the connection straight way. SubSonic was designed to only open the connection when needed and close when finished.

If you want to use the same connection for several queries you need to look in to the batch query

Related Solutions

Sql – Is connection pooling working correctly in Subsonic

There is a way for a connection to remain open when using SubSonic. Many people assume that when you load a collection the reader will be closed for you - but it's not (a class should never act on another class without permission). There is a method called "LoadAndCloseReader()" just for this reason.

If you could find out more that would be great.

SQL Views in SubSonic 3.0

To include views in your project

simply open SQLServer.ttinclude Find the query that load the tables ( search form 'const string TABLE_SQL') then change it to

const string TABLE_SQL=@"SELECT *
    FROM  INFORMATION_SCHEMA.TABLES
    WHERE TABLE_TYPE='BASE TABLE' 
    union
    select Table_catalog, table_schema, table_name, 'View' table_type 
    from information_schema.views";

if you are using it in an asp.net project you can exclude the aspnet table and views like so

const string TABLE_SQL=@"SELECT *
    FROM  INFORMATION_SCHEMA.TABLES
    WHERE TABLE_TYPE='BASE TABLE' 
        and table_name not like '%aspnet_%'
    union
    select Table_catalog, table_schema, table_name, 'View' table_type 
    from information_schema.views
    where table_name not like '%aspnet_%'";

Best Answer

Related Solutions

Sql – Is connection pooling working correctly in Subsonic

SQL Views in SubSonic 3.0

Related Topic