C#

Member 11567959 wrote:

please help me

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand cmd = new SqlCommand("SELECT Id, description FROM myTable", con))
        {
        using (SqlDataReader reader = cmd.ExecuteReader())
            {
            while (reader.Read())
                {
                int id = (int) reader["Id"];
                string desc = (string) reader["description"];
                Console.WriteLine("ID: {0}\n    {1}", id, desc);
                }
            }
        }
    }

public abstract class Car
    {
    public int InCar { get; set; }
    }
public class Porche : Car
    {
    public string InPorche { get; set; }
    }
public class Toyota: Car
    {
    public int InToyota { get; set; }
    }

Porche p = new Porche();
p.InCar = 111;
p.InPorche = "ppp";
Toyota t = new Toyota();
t.InCar = 222;
t.InToyota = 666;
List<Car> cars = new List<Car>() { p, t };
JsonSerializerSettings settings = new JsonSerializerSettings { TypeNameHandling = TypeNameHandling.All };
string json = JsonConvert.SerializeObject(cars, settings);
List<Car> result =JsonConvert.DeserializeObject<List<Car>>(json, settings);

devvvy wrote:

var carTypes = (from type in types
                where type.IsClass && type == typeof(Car)
                select type);

var carTypes = (from type in types
                where type.IsClass && !type.IsAbstract && type.IsAssignableFrom(typeof(Car))
                select type);

var listType = typeof(List<>).MakeGenericType(carType);
var cars = (IReadOnlyList<Car>)Newtonsoft.Json.JsonConvert.DeserializeObject(json, listType);

if(MethodCall(p1,p2,p3)||(MethodCall(p2,p3,p4) || MethodCall(p3,p4,p5)){
outcome = AnotherMethodCall(true, someIntValue);
}