dbDLL | Documentation

Connection String

Classic SQL Connection

                        private void OpenSqlConnection()
                        {
                        // "DataSource":Server IP or Name with Instance Name. For example "(local)" or "10.1.1.2\sql2016"
                        // "DatabaseName":Initial Catalog / Database Name
                        // "IntegratedSecurity":If using windows account to connect server set true, otherwise false and set UserID and Password
                        // "UserID":SQL Server login account name
                        // "Password":account password
                        // "ConnectTimeOut":Length of time (seconds) for wait to connection
                        // "MARS":If you want to open multiple data reader in same time must set true
                        // "AppName":Application name using for when you see in Activity Monitor. Whitch application now are connected?
                        db.ConnectionString = db.Build_SqlConnection_String("(local)", "master", false, "sa", "12345678", 20, true, Application.ProductName + " v" + Application.ProductVersion);
                        if (db.OpenSqlConnection())
                        txtConnStatus.Text = "Connection is open";
                        else
                        txtConnStatus.Text = db.LastException_Message;
                        }

Asp NET MVC Global asax Connection

using dbdll;
namespace dbDLL_APP
{
    public class MvcApplication : System.Web.HttpApplication
    {
        db.ConnectionString = db.Build_SqlConnection_String("(local)", "master", false, "sa", "12345678", 20, true, Application.ProductName + " v" + Application.ProductVersion);

        protected void Application_Start()
        {
            AreaRegistration.RegisterAllAreas();
            FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
            RouteConfig.RegisterRoutes(RouteTable.Routes);
            BundleConfig.RegisterBundles(BundleTable.Bundles);

            db.OpenSqlConnection();
        }
    }
}

Database Operations

Easily Insert a Record to The Table

Set fields with values and call Insert() method. Thats all.

If you want to encrypt sensitive text please use dEncryption() method. Before using must set Crypto Key. The key also need when you want to decrypt enrypted text

crypto.SetCryptoKey("DB-TEST-CUST");
dRec cust = new dRec("dbo.customer");
cust.fields["email"] = "john.lennon@gmail.com";
cust.fields["Name"] = "John Lennon";
cust.fields["Password"] = "abc123xyz".dEncryption();
if (cust.Insert() >= 0)
    txtRecStatusCust.Text = "record inserted";
else
    txtRecStatusCust.Text = "record error:" + db.LastException_Message;

Easily Update a Record on The Table

Set fields to "where" object to which record(s) you need to update. Set other fields with values (to want update) and call Update() method. Thats all.

                        crypto.SetCryptoKey("DB-TEST-CUST");
                        dRec cust = new dRec("dbo.customer");
                        //For where clause
                        cust.where["email"] = "john.lennon@gmail.com";

                        cust.fields["Name"] = "John Lennon";
                        cust.fields["Password"] = "123abc456".dEncryption();
                        if (cust.Update())
                        txtRecStatusCust.Text = "record(s) Updated";
                        else
                        txtRecStatusCust.Text = "record error:" + db.LastException_Message;

Stored Procedure with Select Return(s)

Set fields with values and call ExecuteSPDataSet() method. Thats all.

dRec rec = new dRec("sp_name");
rec.fields.Add("field1", value1);
rec.fields.Add("field2", value2);
rec.fields.Add("field3", value3); 
Object ds = rec.ExecuteSPDataSet();

Delete

Easy delete a record/or records from the table

dRec cust = new dRec("dbo.customer");
cust.where["email"] = "john.lennon@gmail.com";
if (cust.Delete())
    txtRecStatusCust.Text = "record(s) deleted";
else
    txtRecStatusCust.Text = "record error:" + db.LastException_Message;

Marge (Insert/Update together)

This method based on MS-SQL MERGE sql command. When don't know the record is present or not. But you want to be present in any cases.

crypto.SetCryptoKey("DB-TEST-CUST");
dRec cust = new dRec("dbo.customer");
cust.where["email"] = "john.lennon@gmail.com";

cust.fields["Name"] = "John Lennon";
cust.fields["Password"] = "q1w2e3r4".dEncryption();
if (cust.MergeInsertUpdate())
    txtRecStatusCust.Text = "record Updated or Inserted";
else
    txtRecStatusCust.Text = "record error:" + db.LastException_Message;

Select records from Table/View

Select record(s) from a Table or View. Select clause is same with common T-SQL language. This query not only for simple select, you can be write complex query that include multiple tables, group by or anything that have result.

//txtEmailCust.Text     : simple text box
//txtTitleCust.Text     : simple text box
//txtPasswordCust.Text  : simple text box
SqlDataReader dr = null;
crypto.SetCryptoKey("DB-TEST-CUST");
if (db.OpenDR(ref dr, string.Format("select * from dbo.customer where email='{0}'", "john.lennon@gmail.com".Replace("'", "''"))))
{
    if (dr.Read())
    {
        txtEmailCust.Text = dr["email"].dToString();
        txtTitleCust.Text = dr["name"].dToString();
        txtPasswordCust.Text = dr["password"].dToString().dDecryption();
    }
    dr.Close();
}

Crypto

Set Crypto Key

Set any string for Encryption() or Decryption() methods. For good cryptology please use minimum 5 characters length.

crypto.SetCryptoKey("DB-TEST");

Encryption

Cryptology methods are work with extensions. Works with any variables or objects with string type

string vEncryptedText = "Lorem ipsum dolor sit amet...".dEncryption();

Decryption

Cryptology methods are work with extensions. Works with any variables or objects with string type

string vOpenText = @"!M±NM¹N²MsN½M N£M¥NMPNMNMN¢MPN£MN¤MPNMNM¤N^M^N^M@M".dDecryption();
//vOpenText is "Lorem ipsum dolor sit amet..."

Convert Extensions

Some examples for conversion... If any convert error return default in own type.

For String = ""

For Double = 0.0

For Long = 0

                         
dr["email"].dToString();
dr["amount"].dToDouble();
dr["id"].dToLong();

dbDLL NET4 documentation

Methods that will make your database tasks easier for your projects...