Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>What you want is possible, but it is not a nice solution, because you have to wrap all the functions of the <code>MySqlDataReader</code> class and forward it to the real <code>MySqlDataReader</code>. See the <code>ConnectedMySqlDataReader</code> class (hint: it does not implement all functions of MySqlDataReader, if you really want to use it, you have to do it yourself) and how it would fit in your solution:</p> <pre><code>public ConnectedMySqlDataReader GetRecord(string query) { return new ConnectedMySqlDataReader(connectionString, query); } // ... var sql = "SELECT * FROM `table`"; using(var dr = objDB.GetRecord(sql)) { if (dr.Read()) { // some code goes hear } } </code></pre> <p>i have not tested this class, it is just for demonstration!</p> <pre><code>using System; using System.Collections; using System.Data; using System.Data.Common; using MySql.Data.MySqlClient; namespace MySqlTest { public class ConnectedMySqlDataReader : DbDataReader { private readonly MySqlConnection _connection; private readonly Lazy&lt;MySqlDataReader&gt; _reader; private MySqlCommand _command; public ConnectedMySqlDataReader(MySqlConnection connection, string query) { if(connection == null) throw new ArgumentNullException("connection"); _connection = connection; _reader = new Lazy&lt;MySqlDataReader&gt;(() =&gt; { _connection.Open(); _command = new MySqlCommand(query, _connection); return _command.ExecuteReader(); }); } public ConnectedMySqlDataReader(string connectionString, string query) : this(new MySqlConnection(connectionString), query) { } private MySqlDataReader Reader { get { return _reader.Value; } } public override void Close() { if (_reader.IsValueCreated) _reader.Value.Close(); if(_command != null) _command.Dispose(); _connection.Dispose(); } public override DataTable GetSchemaTable() { return this.Reader.GetSchemaTable(); } public override bool NextResult() { return this.Reader.NextResult(); } public override bool Read() { return this.Reader.Read(); } public override int Depth { get { return this.Reader.Depth; } } public override bool IsClosed { get { return this.Reader.IsClosed; } } public override int RecordsAffected { get { return this.Reader.RecordsAffected; } } public override bool GetBoolean(int ordinal) { return this.Reader.GetBoolean(ordinal); } public override byte GetByte(int ordinal) { return this.Reader.GetByte(ordinal); } public override long GetBytes(int ordinal, long dataOffset, byte[] buffer, int bufferOffset, int length) { return this.Reader.GetBytes(ordinal, dataOffset, buffer, bufferOffset, length); } public override char GetChar(int ordinal) { return this.Reader.GetChar(ordinal); } public override long GetChars(int ordinal, long dataOffset, char[] buffer, int bufferOffset, int length) { return this.Reader.GetChars(ordinal, dataOffset, buffer, bufferOffset, length); } public override Guid GetGuid(int ordinal) { return this.Reader.GetGuid(ordinal); } public override short GetInt16(int ordinal) { return this.Reader.GetInt16(ordinal); } public override int GetInt32(int ordinal) { return this.Reader.GetInt32(ordinal); } public override long GetInt64(int ordinal) { return this.Reader.GetInt64(ordinal); } public override DateTime GetDateTime(int ordinal) { return this.Reader.GetDateTime(ordinal); } public override string GetString(int ordinal) { return this.Reader.GetString(ordinal); } public override object GetValue(int ordinal) { return this.Reader.GetValue(ordinal); } public override int GetValues(object[] values) { return this.Reader.GetValues(values); } public override bool IsDBNull(int ordinal) { return this.Reader.IsDBNull(ordinal); } public override int FieldCount { get { return this.Reader.FieldCount; } } public override object this[int ordinal] { get { return this.Reader[ordinal]; } } public override object this[string name] { get { return this.Reader[name]; } } public override bool HasRows { get { return this.Reader.HasRows; } } public override decimal GetDecimal(int ordinal) { return this.Reader.GetDecimal(ordinal); } public override double GetDouble(int ordinal) { return this.Reader.GetDouble(ordinal); } public override float GetFloat(int ordinal) { return this.Reader.GetFloat(ordinal); } public override string GetName(int ordinal) { return this.Reader.GetName(ordinal); } public override int GetOrdinal(string name) { return this.Reader.GetOrdinal(name); } public override string GetDataTypeName(int ordinal) { return this.Reader.GetDataTypeName(ordinal); } public override Type GetFieldType(int ordinal) { return this.Reader.GetFieldType(ordinal); } public override IEnumerator GetEnumerator() { return this.Reader.GetEnumerator(); } } } </code></pre> <p>PS: this is what <a href="http://msdn.microsoft.com/en-us/library/88c54tsw%28v=vs.71%29.aspx" rel="nofollow">sealed in c# context</a> means, and yes, <code>MySqlDataReader</code> is <code>sealed</code>.</p>
    singulars
    1. This table or related slice is empty.
    1. POInvalid attempt to Read when reader is closed
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USesskar
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload