public static Option <int> SelectIDENTITY(OleDbConnection connection, OleDbTransaction transaction) { var selectCommand = new OleDbCommand("SELECT @@IDENTITY", connection); selectCommand.Transaction = transaction; return(selectCommand.OptionalExecuteScalar <int>().getOptRight()); }
private Option <int> SelectPlanData(OleDbTransaction transaction, String target, String where) { var tableName = "`plan`"; var order = $"SELECT `{target}` FROM {tableName} WHERE {where}"; var command = new OleDbCommand(order, Connection); command.Transaction = transaction; return(command.OptionalExecuteScalar <int>().getOptRight()); }
private Option <int> SelectPlanId(OleDbTransaction transaction, Plan.Recode plan) { var tableName = "`plan`"; var where = $"`requester` = '{plan.Requester}' and `date` = #{plan.Date}# and `time` = '{plan.Time}'"; var order = $"SELECT `id` FROM {tableName} WHERE {where}"; var command = new OleDbCommand(order, Connection); command.Transaction = transaction; Console.WriteLine(order); return(command.OptionalExecuteScalar <int>().getOptRight()); }