xivSolutions

// 1. Coding Style?

// RUBY STYLE Your newer additions seem to take on a Ruby-like (2 space indent) style:
public static void CloneFromObject(this object o, object record) {
  var props = o.GetType().GetProperties();
  var dictionary = record.ToDictionary();

  foreach (var prop in props) {
    var propName = prop.Name;
    foreach (var key in dictionary.Keys) {

xivSolutions

public DynamicModel(string connectionStringName, string tableName = "",
    string primaryKeyField = "", string descriptorField = "") {
    TableName = tableName == "" ? this.GetType().Name : tableName;
    PrimaryKeyField = string.IsNullOrEmpty(primaryKeyField) ? "ID" : primaryKeyField;
    DescriptorField = descriptorField;
    var _providerName = "System.Data.SqlClient";
    
    // --->>> This is not present in alpha version - leaving for now:
    if (!string.IsNullOrWhiteSpace(ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName))
        _providerName = ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName;

xivSolutions

SELECT 
    parent.table_name parent, 
    parent.constraint_name key_name, 
    tc.constraint_type key_type,
        (SELECT c.table_name 
            FROM information_schema.table_constraints c
            WHERE c.constraint_name = parent.constraint_name) child,
        (SELECT pid.column_name
            FROM information_schema.constraint_column_usage pid
            WHERE pid.constraint_name = parent.constraint_name) pid,

xivSolutions

SELECT 
    ctu.table_name table_name, 
    ctu.constraint_name key_name, 
    ccu.column_name
FROM information_schema.table_constraints tc 
  INNER JOIN information_schema.constraint_table_usage ctu
    ON ctu.constraint_name = tc.constraint_name 
  INNER JOIN information_schema.constraint_column_usage ccu 
    ON ccu.constraint_name = ctu.constraint_name
WHERE tc.constraint_type = 'PRIMARY KEY' 

xivSolutions

SELECT 
    tc.constraint_name key_name,
    ctu.table_name parent_table,
    tc.table_name child_table,  
	(SELECT kcu2.column_name 
	    FROM information_schema.table_constraints tc2
		INNER JOIN information_schema.Key_column_usage kcu2
		ON tc2.table_name = kcu2.table_name AND tc2.constraint_name = kcu2.constraint_name
	    WHERE tc2.constraint_type = 'PRIMARY KEY' AND tc2.table_name = ctu.table_name) parent_id,
        (SELECT kcu.column_name

xivSolutions

SELECT * FROM Information_schema.tables t
WHERE t.table_schema NOT In('information_schema', 'pg_catalog');

xivSolutions

var start = process.hrtime();

var elapsed_time = function(note){
    var precision = 3; // 3 decimal places
    var elapsed = process.hrtime(start)[1] / 1000000; // divide by a million to get nano to milli
    console.log(process.hrtime(start)[0] + " s, " + elapsed.toFixed(precision) + " ms - " + note); // print message + time
    start = process.hrtime(); // reset the timer
}

// Example:

xivSolutions

CREATE OR REPLACE FUNCTION searchcustomers(text) RETURNS SETOF customers AS $$
    SELECT * FROM customers WHERE (last_name ILIKE $1 ||'%');
$$ LANGUAGE SQL;

SELECT * FROM searchcustomers('GR') AS t1;

xivSolutions

// LOGIN PARTIAL:

// Change the Views => Shared => _LoginPartial to match this:
@using Microsoft.AspNet.Identity
@if (Request.IsAuthenticated)
{
    using (Html.BeginForm("LogOff", "Account", FormMethod.Post, new { id = "logoutForm", @class = "navbar-right" }))
    {
    @Html.AntiForgeryToken()

xivSolutions

INSERT INTO Transactions (Amount,Comment) 
VALUES (@0,@1),(@2,@3),(@4,@5),(@6,@7),(@8,@9),(@10,@11),(@12,@13),(@14,@15),(@16,@17),(@18,@19)