FromDataReader() public static method

public static FromDataReader ( SQLiteDataReader reader ) : VarEquip
reader SQLiteDataReader
return VarEquip
VarEquip Class Documentation
Exemplo n.º 1
0
        public static VarEquip GetById(int varEquipId)
        {
            VarEquip result = null;

            using (var conn = CacheManager.CreateConnection())
            {
                using (var cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "SELECT * FROM VarEquip WHERE ID = @ID";
                    cmd.Parameters.AddWithValue("@ID", varEquipId);
                    conn.Open();
                    using (var reader = cmd.ExecuteReader(CommandBehavior.SingleRow))
                    {
                        if (reader.Read())
                        {
                            result = VarEquip.FromDataReader(reader);
                        }
                    }
                }
            }
            return(result);
        }