What objects and services do I use to visualize the collection of tables and
the table's collections of columns in a SSCE database file.

Something parallel to excelConn.GetOleDbSchemaTable() but for SSCE to allow
me to see the contents very quickly. The Data Source Display inside vs2005
are slow and not really user friendly. I want to build something along the
lines of the Access interface when in Design mode.

I do not see any objects or methods available in SSCE objects,
(System.Data.SqlServerCe) and info is scarce.


Garry

Re: Catalog of tables in an SSCE database by William

William
Sat Nov 25 11:57:45 CST 2006

Ya, gotta read my new EBook. I explain (therein) that many of these more
sophisticated methods in ADO.NET are not exposed in the SqlCe namespace. The
right way to get the list of object is to use the SQLCe system views. Use
your Server Explorer to drill into a SqlCe (Sql Mobile for now) database and
open the System Views tab. Here you'll see everything that you need
(hopefully).

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
-----------------------------------------------------------------------------------------------------------------------

"Garry" <garrygrolman@gmail.com> wrote in message
news:eT78EfKEHHA.4208@TK2MSFTNGP03.phx.gbl...
> What objects and services do I use to visualize the collection of tables
> and the table's collections of columns in a SSCE database file.
>
> Something parallel to excelConn.GetOleDbSchemaTable() but for SSCE to
> allow me to see the contents very quickly. The Data Source Display inside
> vs2005 are slow and not really user friendly. I want to build something
> along the lines of the Access interface when in Design mode.
>
> I do not see any objects or methods available in SSCE objects,
> (System.Data.SqlServerCe) and info is scarce.
>
>
> Garry
>



Re: Catalog of tables in an SSCE database by Garry

Garry
Sat Nov 25 23:26:56 CST 2006

Thanks

Garry


"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:OEED3sLEHHA.3224@TK2MSFTNGP04.phx.gbl...
> Ya, gotta read my new EBook. I explain (therein) that many of these more
> sophisticated methods in ADO.NET are not exposed in the SqlCe namespace.
> The right way to get the list of object is to use the SQLCe system views.
> Use your Server Explorer to drill into a SqlCe (Sql Mobile for now)
> database and open the System Views tab. Here you'll see everything that
> you need (hopefully).
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> -----------------------------------------------------------------------------------------------------------------------
>
> "Garry" <garrygrolman@gmail.com> wrote in message
> news:eT78EfKEHHA.4208@TK2MSFTNGP03.phx.gbl...
>> What objects and services do I use to visualize the collection of tables
>> and the table's collections of columns in a SSCE database file.
>>
>> Something parallel to excelConn.GetOleDbSchemaTable() but for SSCE to
>> allow me to see the contents very quickly. The Data Source Display inside
>> vs2005 are slow and not really user friendly. I want to build something
>> along the lines of the Access interface when in Design mode.
>>
>> I do not see any objects or methods available in SSCE objects,
>> (System.Data.SqlServerCe) and info is scarce.
>>
>>
>> Garry
>>
>
>



Re: Catalog of tables in an SSCE database by Garry

Garry
Sun Nov 26 02:39:47 CST 2006

Bill,

The point is that I want to access the tables collection IN CODE so that I
can make myself a 'Viewer' tailored to my needs.

I found some sample code using Google using "INFORMATION_SCHEMA.TABLES"
which has allowed me to start implementing my little and 'light' viewer. The
Server Explorer is a bit 'heavy' and can only be used when VS2005 is up and
running..

Contained data is not a problem.

Garry


"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:OEED3sLEHHA.3224@TK2MSFTNGP04.phx.gbl...
> Ya, gotta read my new EBook. I explain (therein) that many of these more
> sophisticated methods in ADO.NET are not exposed in the SqlCe namespace.
> The right way to get the list of object is to use the SQLCe system views.
> Use your Server Explorer to drill into a SqlCe (Sql Mobile for now)
> database and open the System Views tab. Here you'll see everything that
> you need (hopefully).
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> -----------------------------------------------------------------------------------------------------------------------
>
> "Garry" <garrygrolman@gmail.com> wrote in message
> news:eT78EfKEHHA.4208@TK2MSFTNGP03.phx.gbl...
>> What objects and services do I use to visualize the collection of tables
>> and the table's collections of columns in a SSCE database file.
>>
>> Something parallel to excelConn.GetOleDbSchemaTable() but for SSCE to
>> allow me to see the contents very quickly. The Data Source Display inside
>> vs2005 are slow and not really user friendly. I want to build something
>> along the lines of the Access interface when in Design mode.
>>
>> I do not see any objects or methods available in SSCE objects,
>> (System.Data.SqlServerCe) and info is scarce.
>>
>>
>> Garry
>>
>
>



Re: Catalog of tables in an SSCE database by William

William
Mon Nov 27 10:52:33 CST 2006

You found the right System View. I think the Orcas version of VS is going to
have (much) better support as well as a few new wrinkles.
Good luck with your project. I'm sure the EBook will help... ;)

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
-----------------------------------------------------------------------------------------------------------------------

"Garry" <garrygrolman@gmail.com> wrote in message
news:uVVgtZTEHHA.3396@TK2MSFTNGP02.phx.gbl...
> Bill,
>
> The point is that I want to access the tables collection IN CODE so that I
> can make myself a 'Viewer' tailored to my needs.
>
> I found some sample code using Google using "INFORMATION_SCHEMA.TABLES"
> which has allowed me to start implementing my little and 'light' viewer.
> The Server Explorer is a bit 'heavy' and can only be used when VS2005 is
> up and running..
>
> Contained data is not a problem.
>
> Garry
>
>
> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
> news:OEED3sLEHHA.3224@TK2MSFTNGP04.phx.gbl...
>> Ya, gotta read my new EBook. I explain (therein) that many of these more
>> sophisticated methods in ADO.NET are not exposed in the SqlCe namespace.
>> The right way to get the list of object is to use the SQLCe system views.
>> Use your Server Explorer to drill into a SqlCe (Sql Mobile for now)
>> database and open the System Views tab. Here you'll see everything that
>> you need (hopefully).
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "Garry" <garrygrolman@gmail.com> wrote in message
>> news:eT78EfKEHHA.4208@TK2MSFTNGP03.phx.gbl...
>>> What objects and services do I use to visualize the collection of tables
>>> and the table's collections of columns in a SSCE database file.
>>>
>>> Something parallel to excelConn.GetOleDbSchemaTable() but for SSCE to
>>> allow me to see the contents very quickly. The Data Source Display
>>> inside vs2005 are slow and not really user friendly. I want to build
>>> something along the lines of the Access interface when in Design mode.
>>>
>>> I do not see any objects or methods available in SSCE objects,
>>> (System.Data.SqlServerCe) and info is scarce.
>>>
>>>
>>> Garry
>>>
>>
>>
>
>



Re: Catalog of tables in an SSCE database by W

W
Tue Nov 28 07:33:33 CST 2006

So where does one procure this ebook ;-) ? Is it out now?
"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:Ot8ExRkEHHA.4832@TK2MSFTNGP06.phx.gbl...
> You found the right System View. I think the Orcas version of VS is going
> to have (much) better support as well as a few new wrinkles.
> Good luck with your project. I'm sure the EBook will help... ;)
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> -----------------------------------------------------------------------------------------------------------------------
>
> "Garry" <garrygrolman@gmail.com> wrote in message
> news:uVVgtZTEHHA.3396@TK2MSFTNGP02.phx.gbl...
>> Bill,
>>
>> The point is that I want to access the tables collection IN CODE so that
>> I can make myself a 'Viewer' tailored to my needs.
>>
>> I found some sample code using Google using "INFORMATION_SCHEMA.TABLES"
>> which has allowed me to start implementing my little and 'light' viewer.
>> The Server Explorer is a bit 'heavy' and can only be used when VS2005 is
>> up and running..
>>
>> Contained data is not a problem.
>>
>> Garry
>>
>>
>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
>> news:OEED3sLEHHA.3224@TK2MSFTNGP04.phx.gbl...
>>> Ya, gotta read my new EBook. I explain (therein) that many of these more
>>> sophisticated methods in ADO.NET are not exposed in the SqlCe namespace.
>>> The right way to get the list of object is to use the SQLCe system
>>> views. Use your Server Explorer to drill into a SqlCe (Sql Mobile for
>>> now) database and open the System Views tab. Here you'll see everything
>>> that you need (hopefully).
>>>
>>> --
>>> ____________________________________
>>> William (Bill) Vaughn
>>> Author, Mentor, Consultant
>>> Microsoft MVP
>>> INETA Speaker
>>> www.betav.com/blog/billva
>>> www.betav.com
>>> Please reply only to the newsgroup so that others can benefit.
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>> __________________________________
>>> Visit www.hitchhikerguides.net to get more information on my latest
>>> book:
>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>>> -----------------------------------------------------------------------------------------------------------------------
>>>
>>> "Garry" <garrygrolman@gmail.com> wrote in message
>>> news:eT78EfKEHHA.4208@TK2MSFTNGP03.phx.gbl...
>>>> What objects and services do I use to visualize the collection of
>>>> tables and the table's collections of columns in a SSCE database file.
>>>>
>>>> Something parallel to excelConn.GetOleDbSchemaTable() but for SSCE to
>>>> allow me to see the contents very quickly. The Data Source Display
>>>> inside vs2005 are slow and not really user friendly. I want to build
>>>> something along the lines of the Access interface when in Design mode.
>>>>
>>>> I do not see any objects or methods available in SSCE objects,
>>>> (System.Data.SqlServerCe) and info is scarce.
>>>>
>>>>
>>>> Garry
>>>>
>>>
>>>
>>
>>
>
>



Re: Catalog of tables in an SSCE database by William

William
Tue Nov 28 15:12:52 CST 2006

Sure, for you we'll extended the 50%-off earlybird discount ($9.95 US) at
http://www.hitchhikerguides.net/EBooks/default.aspx.


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
-----------------------------------------------------------------------------------------------------------------------

"W.G. Ryan [MVP]" <WilliamRyan@nospam.gmail.com> wrote in message
news:OuVdNHvEHHA.4608@TK2MSFTNGP02.phx.gbl...
> So where does one procure this ebook ;-) ? Is it out now?
> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
> news:Ot8ExRkEHHA.4832@TK2MSFTNGP06.phx.gbl...
>> You found the right System View. I think the Orcas version of VS is going
>> to have (much) better support as well as a few new wrinkles.
>> Good luck with your project. I'm sure the EBook will help... ;)
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "Garry" <garrygrolman@gmail.com> wrote in message
>> news:uVVgtZTEHHA.3396@TK2MSFTNGP02.phx.gbl...
>>> Bill,
>>>
>>> The point is that I want to access the tables collection IN CODE so that
>>> I can make myself a 'Viewer' tailored to my needs.
>>>
>>> I found some sample code using Google using "INFORMATION_SCHEMA.TABLES"
>>> which has allowed me to start implementing my little and 'light' viewer.
>>> The Server Explorer is a bit 'heavy' and can only be used when VS2005 is
>>> up and running..
>>>
>>> Contained data is not a problem.
>>>
>>> Garry
>>>
>>>
>>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
>>> news:OEED3sLEHHA.3224@TK2MSFTNGP04.phx.gbl...
>>>> Ya, gotta read my new EBook. I explain (therein) that many of these
>>>> more sophisticated methods in ADO.NET are not exposed in the SqlCe
>>>> namespace. The right way to get the list of object is to use the SQLCe
>>>> system views. Use your Server Explorer to drill into a SqlCe (Sql
>>>> Mobile for now) database and open the System Views tab. Here you'll see
>>>> everything that you need (hopefully).
>>>>
>>>> --
>>>> ____________________________________
>>>> William (Bill) Vaughn
>>>> Author, Mentor, Consultant
>>>> Microsoft MVP
>>>> INETA Speaker
>>>> www.betav.com/blog/billva
>>>> www.betav.com
>>>> Please reply only to the newsgroup so that others can benefit.
>>>> This posting is provided "AS IS" with no warranties, and confers no
>>>> rights.
>>>> __________________________________
>>>> Visit www.hitchhikerguides.net to get more information on my latest
>>>> book:
>>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>>>> -----------------------------------------------------------------------------------------------------------------------
>>>>
>>>> "Garry" <garrygrolman@gmail.com> wrote in message
>>>> news:eT78EfKEHHA.4208@TK2MSFTNGP03.phx.gbl...
>>>>> What objects and services do I use to visualize the collection of
>>>>> tables and the table's collections of columns in a SSCE database file.
>>>>>
>>>>> Something parallel to excelConn.GetOleDbSchemaTable() but for SSCE to
>>>>> allow me to see the contents very quickly. The Data Source Display
>>>>> inside vs2005 are slow and not really user friendly. I want to build
>>>>> something along the lines of the Access interface when in Design mode.
>>>>>
>>>>> I do not see any objects or methods available in SSCE objects,
>>>>> (System.Data.SqlServerCe) and info is scarce.
>>>>>
>>>>>
>>>>> Garry
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>