C#

select a.Column1,a.Column2 from TableA a
union all
select b.Column1,b.Column2 from TableB b

larsp777 wrote:

I have to add

Bastard Programmer from Hell

larsp777 wrote:

Also in my derived classes I declare another type of object. It´s a
library-system. It has a List of book-objects.

larsp777 wrote:

It works without derived classes but not when I try with derived classes.

Bastard Programmer from Hell

larsp777 wrote:

Not sure what you mean but I declared a List of objects like:
 

List<book> BookList = new List<book>();

Error CS0246: The type or namespace name 'List' could not be found (are you missing a using directive or an assembly reference?)

System.Collection.Generic.List<Book> bookList = 
    new System.Collections.Generic.List<Book>();

Bastard Programmer from Hell

using (Stream s2 = File.Create(path2))
          {
              xs2.Serialize(s2, BookList);
          }

public static String SerialiseToString<T>(T data, Type[] additionalTypes) {
  XmlSerializer serializer = new XmlSerializer(typeof(T), additionalTypes);
  using (StringWriter writer = new StringWriter()) {
    serializer.Serialize(writer, data);
    return writer.ToString();
  }
}

public static T DeserialiseFromString<T>(String xmlstr, Type[] additionalTypes) {
  using (StringReader reader = new StringReader(xmlstr)) {
    XmlSerializer serializer = new XmlSerializer(typeof(T), additionalTypes);
    T temp = (T)serializer.Deserialize(reader);
    return temp;
  }
}

List<Book> lst = new List<Book>();
Book one = new Book();

one.Title = "Swallows and Amazons";
one.Author = "Arthur Ransome";
lst.Add(one);

EBook two = new EBook();
two.Title = "War Horse";
two.Author = "Michael Morpurgo";
two.Platform = "Kindle";
lst.Add(two);
String xmlData = SerialiseToString<List<Book>>(lst, new Type[]{typeof(EBook)});

<?xml version="1.0" encoding="utf-16"?>
<ArrayOfBook xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Book>
    <Title>Swallows and Amazons</Title>
    <Author>Arthur Ransome</Author>
  </Book>
  <Book xsi:type="EBook">
    <Title>War Horse</Title>
    <Author>Michael Morpurgo</Author>
    <Platform>Kindle</Platform>
  </Book>
</ArrayOfBook>

List<Book> lst = DeserialiseFromString<List<Book>>(xmlData, new Type[]{typeof(EBook)});