SQLite in VS2015 Server Explorer (Bugs)

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

SQLite in VS2015 Server Explorer (Bugs)

Tyler Merle
I believe I’ve uncovered two bugs when using VS2015’s Server Explorer to design a SQLite schema.

1. When adding more than one relationship to a table, the first relationship’s “to” table name is used for all new relationships
2. The right-click -> design option for tables doesn’t open the table design on the first try. Takes two right-click -> design selections to open the designer
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQLite in VS2015 Server Explorer (Bugs)

Stephan Beal-3
On Tue, Aug 23, 2016 at 4:13 PM, Tyler Merle <[hidden email]> wrote:

> I believe I’ve uncovered two bugs when using VS2015’s Server Explorer to
> design a SQLite schema.
>
> 1. When adding more than one relationship to a table, the first
> relationship’s “to” table name is used for all new relationships
> 2. The right-click -> design option for tables doesn’t open the table
> design on the first try. Takes two right-click -> design selections to open
> the designer
>

Wrong mailing list. This is the list for the sqlite library and its shell
program (neither of which include a schema design tool). Server Explorer is
a 3rd-party product.

--
----- stephan beal
http://wanderinghorse.net/home/stephan/
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQLite in VS2015 Server Explorer (Bugs)

Drago, William @ CSG - NARDA-MITEQ
> -----Original Message-----
> From: sqlite-users [mailto:[hidden email]] On
> Behalf Of Stephan Beal
> Sent: Wednesday, August 24, 2016 6:37 AM
> To: SQLite mailing list <[hidden email]>
> Subject: Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)
>
> On Tue, Aug 23, 2016 at 4:13 PM, Tyler Merle <[hidden email]> wrote:
>
> > I believe I’ve uncovered two bugs when using VS2015’s Server Explorer
> > to design a SQLite schema.
> >
> > 1. When adding more than one relationship to a table, the first
> > relationship’s “to” table name is used for all new relationships 2.
> > The right-click -> design option for tables doesn’t open the table
> > design on the first try. Takes two right-click -> design selections to
> > open the designer
> >
>
> Wrong mailing list. This is the list for the sqlite library and its shell program
> (neither of which include a schema design tool). Server Explorer is a 3rd-party
> product.

This is also the list for System.Data.SQLite. System.Data.SQLite supports design time components for VS2015, so this may be the correct list for questions regarding issues with using SQLite and Visual Studio's server explorer.

--
Bill Drago
Staff Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / [hidden email]
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQLite in VS2015 Server Explorer (Bugs)

Simon Slavin-3

On 24 Aug 2016, at 12:33pm, Drago, William @ CSG - NARDA-MITEQ <[hidden email]> wrote:

> This is also the list for System.Data.SQLite. System.Data.SQLite supports design time components for VS2015, so this may be the correct list for questions regarding issues with using SQLite and Visual Studio's server explorer.

Sort-of agreed, but the bugs here are definitely not bugs in System.Data.SQLite, which can do both of those underlying tasks without error.  So the bugs must be elsewhere.

Simon.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQLite in VS2015 Server Explorer (Bugs)

Scott Robison-2
In reply to this post by Stephan Beal-3
On Aug 24, 2016 5:35 AM, "Simon Slavin" <[hidden email]> wrote:
>
>
> On 24 Aug 2016, at 12:33pm, Drago, William @ CSG - NARDA-MITEQ
<[hidden email]> wrote:
>
> > This is also the list for System.Data.SQLite. System.Data.SQLite
supports design time components for VS2015, so this may be the correct list
for questions regarding issues with using SQLite and Visual Studio's server
explorer.
>
> Sort-of agreed, but the bugs here are definitely not bugs in
System.Data.SQLite, which can do both of those underlying tasks without
error.  So the bugs must be elsewhere.

That seems reasonable at first blush, but I don't know what level of
cooperation is required from System.Data.SQLite to accommodate this
functionality. You could be right, but given past similar emails, I doubt
either of us is.

I'm sure the responsible party will see this and reply shortly with
something definitive.

>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQLite in VS2015 Server Explorer (Bugs)

Joe Mistachkin-3

Scott Robison wrote:
>
> I'm sure the responsible party will see this and reply shortly with
> something definitive.
>

This is the right place and the System.Data.SQLite design-time components
are supported here.

That being said, the design-time components for System.Data.SQLite are
supported on a "best effort" basis, mostly because:

        1. They were never fully completed.

        2. The Visual Studio extensibility interfaces they use are very
           fragile and scarcely documented.

        3. Debugging them is nefariously difficult.

--
Joe Mistachkin @ https://urn.to/r/mistachkin

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQLite in VS2015 Server Explorer (Bugs)

Erik Ejlskov Jensen
In reply to this post by Stephan Beal-3
As an alternative to the System.data.sqlite design tools (depending on your requirements) you can use my free VS extension "SQLite Toolbox" https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/
Mvh / Regards


Erik Ejlskov Jensen
http://twitter.com/erikej     
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: SQLite in VS2015 Server Explorer (Bugs)

Delvin
Mr. Jensen,

Thank you for the link - Although I am moving away from MS VS (I am using Dev-C++ more than MS VS) I have installed your MS VS Add-on so hopefully I will be able to use it soon.

Thank you again
Delvin


-----Original Message-----
From: sqlite-users [mailto:[hidden email]] On Behalf Of Erik Ejlskov Jensen
Sent: Thursday, 25 August, 2016 07:05
To: [hidden email]
Subject: Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

As an alternative to the System.data.sqlite design tools (depending on your requirements) you can use my free VS extension "SQLite Toolbox" https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/
Mvh / Regards


Erik Ejlskov Jensen
http://twitter.com/erikej     
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users