{"action":"created","issue":{"url":"https://api.github.com/repos/dotnet/corefx/issues/5024","labels_url":"https://api.github.com/repos/dotnet/corefx/issues/5024/labels{/name}","comments_url":"https://api.github.com/repos/dotnet/corefx/issues/5024/comments","events_url":"https://api.github.com/repos/dotnet/corefx/issues/5024/events","html_url":"https://github.com/dotnet/corefx/issues/5024","id":122622356,"number":5024,"title":"Define the Schema Objects for the DbConnection getSchema","user":{"login":"saurabh500","id":1623701,"avatar_url":"https://avatars.githubusercontent.com/u/1623701?v=3","gravatar_id":"","url":"https://api.github.com/users/saurabh500","html_url":"https://github.com/saurabh500","followers_url":"https://api.github.com/users/saurabh500/followers","following_url":"https://api.github.com/users/saurabh500/following{/other_user}","gists_url":"https://api.github.com/users/saurabh500/gists{/gist_id}","starred_url":"https://api.github.com/users/saurabh500/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/saurabh500/subscriptions","organizations_url":"https://api.github.com/users/saurabh500/orgs","repos_url":"https://api.github.com/users/saurabh500/repos","events_url":"https://api.github.com/users/saurabh500/events{/privacy}","received_events_url":"https://api.github.com/users/saurabh500/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/dotnet/corefx/labels/System.Data","name":"System.Data","color":"d4c5f9"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-12-16T22:54:53Z","updated_at":"2015-12-28T15:30:58Z","closed_at":null,"body":"Ref issue https://github.com/dotnet/corefx/issues/3423\r\n\r\nThe Database schema being exposed by the DbConnection.GetSchema() needs to return the schema of the database.\r\n\r\nThe API should expose strongly typed objects. Issue #3423 is an effort to design the DbColumn representing the Column schema which will be one of the items of the collection of Base types which the Database schema should expose. \r\n\r\n\r\nThis issue is for the discussion of the Types for the schema and refining the types.\r\n\r\nI will add more details here as we come up with the design.\r\n\r\nThe Base types will be added to System.Data.Common and an API will be added to the DbConnection exposing the top level schema object.\r\n"},"comment":{"url":"https://api.github.com/repos/dotnet/corefx/issues/comments/167589259","html_url":"https://github.com/dotnet/corefx/issues/5024#issuecomment-167589259","issue_url":"https://api.github.com/repos/dotnet/corefx/issues/5024","id":167589259,"user":{"login":"skyhoshi","id":5558629,"avatar_url":"https://avatars.githubusercontent.com/u/5558629?v=3","gravatar_id":"","url":"https://api.github.com/users/skyhoshi","html_url":"https://github.com/skyhoshi","followers_url":"https://api.github.com/users/skyhoshi/followers","following_url":"https://api.github.com/users/skyhoshi/following{/other_user}","gists_url":"https://api.github.com/users/skyhoshi/gists{/gist_id}","starred_url":"https://api.github.com/users/skyhoshi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/skyhoshi/subscriptions","organizations_url":"https://api.github.com/users/skyhoshi/orgs","repos_url":"https://api.github.com/users/skyhoshi/repos","events_url":"https://api.github.com/users/skyhoshi/events{/privacy}","received_events_url":"https://api.github.com/users/skyhoshi/received_events","type":"User","site_admin":false},"created_at":"2015-12-28T15:30:58Z","updated_at":"2015-12-28T15:30:58Z","body":"After reading (most) of the discussion chain starting in #1039 I was curious as to how you might handle FileStreams, as they are of the VarBinary DataType I didn't see much discussion around the less basic Data types. e.g. Spacial's, FileStreams and the more complex data types. \r\n\r\nits my assumption that these can be broken down into more simple data types such as the backing VarBinary(Max) for the file streams and decimals(floats) for Spacial's, though it would be reassuring to hear these complex types addressed as well. \r\n\r\nI appreciate the distance this conversation has traveled and I wouldn't want to muck the conversation up though these data type can muddy up the waters a bit when dealing with a [DataType] abstraction. the conversation has been light on details of these more complex SQL Data Types. \r\n\r\nThese data types are a bit more \"Product Specific\" than this discussion chain would require but having said that the \"GetSchemaTable()\" or Meta Data Retrieval Methods used should be brethed enough to deal with these more complex and qualified Data Types."}}