Schemas abstraction/removal

[haf]

Example, works with SQLite:

let private insertMetric schema (m : Measure) connMgr =
  Sql.execNonQuery connMgr
    "INSERT INTO Metrics (Path, EpochTicks, Level, Type, Value)
     VALUES (@path, @epoch, @level, @type, @value)"
    [ P("@path", m.path)
      P("@epoch", m.timestamp.Ticks)
      P("@level", m.level.ToInt())
      P("@type", m.mtype.ToString())
      P("@value", m.value) ]

What I'd want for SQLServer:

let private insertMetric schema (m : Measure) connMgr =
  Sql.execNonQuery connMgr
    (sprintf "INSERT INTO %s.Metrics (Path, EpochTicks, Level, Type, Value)
     VALUES (@path, @epoch, @level, @type, @value)" schema)
    [ P("@path", m.path)
      P("@epoch", m.timestamp.Ticks)
      P("@level", m.level.ToInt())
      P("@type", m.mtype.ToString())
      P("@value", m.value) ]

Is there an existing way of doing schemas transparently in FsSql?

[mausch]

Nope, there's nothing to do this and I think it's out of the scope of FsSql (just as it's out of the scope of ADO.NET).

[haf]

ADO.Net has logging, so that is incorrect.

[mausch]

This issue is about "Schemas abstraction/removal", not logging.

[mausch]

You might want to implement this with a custom IDbConnection parsing and modifying the CommandText before passing it to the real IDbConnection. The wrappers I committed for https://github.com/mausch/FsSql/issues/19 should help, the principle is similar.