Oracle – SSDT in Visual Studio 2015 Oracle Connection Issue

Well, glad I asked. The solution I finally discovered was here:

How do I configure SQL Server Express to allow remote tcp/ip connections on port 1433?

1. Run SQL Server Configuration Manager.
2. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
3. Make sure TCP/IP is enabled.

So far, so good, and entirely expected. But then:

1. Right-click on TCP/IP and select Properties.
2. Verify that, under IP2, the IP Address is set to the computer's IP address on the local subnet.
3. Scroll down to IPAll.
4. Make sure that TCP Dynamic Ports is blank. (Mine was set to some 5-digit port number.)
5. Make sure that TCP Port is set to 1433. (Mine was blank.)

(Also, if you follow these steps, it's not necessary to enable SQL Server Browser, and you only need to allow port 1433, not 1434.)

These extra five steps are something I can't remember ever having had to do in a previous version of SQL Server, Express or otherwise. They appear to have been necessary because I'm using a named instance (myservername\SQLEXPRESS) on the server instead of a default instance. See here:

Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)

Well, not sure exactly what you're trying to do here, but an anonymous type != a Table object. The exception indicates you're trying to cast an IEnum of an anonymous type (a compiler-generated class with a weird name) to an IEnum of type Table.

You can't cast types willy nilly in C#. You can't, for instance, do this:
(Table)"Lol I'd like to be a table pls kthx"
You can't cast any type that isn't already a Table, or extends from Table, to a Table.

So what you're asking is impossible. You should probably take a step back and ask a more general question about what you're trying to accomplish.

Some more on anon types... They only really have meaning within the scope of the method in which they are defined. It appears you might be returning your anon type enumeration from a method call and then are attempting to sort. This won't work, as once the anonymous type leaves the method scope it is considered (at least by intellisense) to be an object and the only way to get at its properties is to use reflection.

If your example isn't just a simplified version, you could just skip the anon type altogether...

this.bindingSource.DataSource = 
    from row in db.Table
    select row.Name + row.Num.ToString();

This is an IEnumerable, and can be queried thusly:

var query = from row in anotherBindingSource
            where row.StartsWith("asd")
            select row;

However it doesn't look like you're accomplishing much at all with this...

You cannot query anonymous types outside of the scope in which they are defined.

This works:

public void Worthless(Hurr hurr)
{
  var query = from x in hurr select new { x.Durr };

  var requery = from x in query where x.Durr == "lol" select x;
}

This does not:

public class Anonymous
{
  public IEnumerable GetMyDurrs(Hurr hurr)
  {
    return from x in Hurr select new { x.Durr };
  }

  public IEnumerable WeedMyDurrs(Hurr hurr, string value)
  {
    // this won't compile
    return from x in GetMyDurrs(hurr) where x.Durr == value select x;
  }
}

The second example won't compile because the anonymous type was defined within another scope.

The only way to get this to work is to define a type.

public class Anonymous
{
  public IEnumerable<Anonymous.MyDurr> GetMyDurrs(Hurr hurr)
  {
    return from x in Hurr select new MyDurr { Durr = x.Durr };
  }

  public IEnumerable<Anonymous.MyDurr> WeedMyDurrs(Hurr hurr, string value)
  {
    // this won't compile
    return from x in GetMyDurrs(hurr) where x.Durr == value select x;
  }

  public class MyDurr { public string Durr {get;set;} }
}