Re: [sqlite] Provider not showing up in .Net Model import wizard

[Freeliner]

Looks like I found a small workaround for absence of SQLite DataSource in the
list when trying to start New Connection after choosing "Update Model From
Database..." or "Generate Database from Model..." from your edmx file:

Strangely, but "SQLite Database File" data source  *exists* in the same
selection list when accessing it via 
"Tools-Connect To Database..." Visual Studio menu.

 


 

So first of all you can create a data connection in Visual Studio to an
SQLite file in that menu.
After that press drop-down list of existing database connections and find
that one which you have just created. After that you can proceed with your
operation.

PS. I have just found out - that after you complete this operation - "SQLite
Database File" finally appears in drop-down selection list even when you try
to access it via edmx model context menu:

 





--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Provider-not-showing-up-in-Net-Model-import-wizard-tp75306p78026.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Provider not showing up in .Net Model import wizard

[Joe Mistachkin]

Freeliner wrote:
>
> I still do not see any SQLite DataSource:
> 
>  
> 
> I am sure there must be some important step which I have missed after
> installation.
> I will appreciate any suggestions on this topic.
> 
 
Are you able to add a System.Data.SQLite-based connection via the Server
Explorer
Window?

If so, can you try adding the "System.Data.SQLite" NuGet package (NOTE: this
MUST
be version 1.0.94.1) to your project (which also includes EF6 support)?

This should also setup the appropriate entries in the "App.config" file.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Provider not showing up in .Net Model import wizard

[Freeliner]

The problems in this question closely resemble those which I have met with my
project with Visual Studio support.

I've followed recommendations by visiting
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
and choosing *sqlite-netFx40-setup-bundle-x86-2010-1.0.94.0.exe* to download
since it is targeted for VS 2010 and states as "*capable of installing the
design-time components for Visual Studio 2010*".

I've installed it, checking options to install design-time VS components:

 

However, still after restarting VS and trying to generate database from the
model:

 

I still do not see any SQLite DataSource:

 

I am sure there must be some important step which I have missed after
installation.
I will appreciate any suggestions on this topic.



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Provider-not-showing-up-in-Net-Model-import-wizard-tp75306p78023.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Provider not showing up in .Net Model import wizard

[Joachim K.]

You need to download and install the proper version. This one from the
download page works fine for me:
sqlite-netFx451-setup-bundle-x86-2013-1.0.92.0.exe

Joachim


On Fri, Apr 25, 2014 at 12:27 AM, Sean McBride wrote:

> Thanks for your reply Joe!
>
> I think I am just not getting across exactly where I expect SQLite to show
> up.  I am pretty sure it is supposed to be there because there are
> tutorials floating around that show screen shots with the SQLite source
> showing up where I would expect it to.
>
> For example, in this tutorial: (specifically the 6th screen shot)
>
> http://www.geekswithblogs.net/danielggarcia/archive/2013/12/22/portable-databases-ii-using-sqlite-with-entity-framework.aspx
>
> It shows the .Net Data provider for SQLite in the drop down.
>
> Any idea why this wouldn’t be working or what other step I am missing that
> would make this show up there?
>
> Thanks
> Sean
>
> On Apr 24, 2014, at 1:01 PM, Joe Mistachkin  wrote:
>
> >
> > Sean McBride wrote:
> >>
> >> I installed the NuGet packages (the one with all 3 modules) into my C#
> > project.
> >>
> >> I want to import an existing SQLite DB and create a Entity Data Model
> from
> > it.
> >> But, when I try to generate from database, the data source and provider
> do
> > not
> >> appear in the list.
> >>
> >
> > None of the NuGet packages for System.Data.SQLite install the design-time
> > components
> > for Visual Studio, since that would require various machine-wide changes.
> >
> > --
> > Joe Mistachkin
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Provider not showing up in .Net Model import wizard

[Sean McBride]

Thanks for your reply Joe!

I think I am just not getting across exactly where I expect SQLite to show up.  
I am pretty sure it is supposed to be there because there are tutorials 
floating around that show screen shots with the SQLite source showing up where 
I would expect it to.

For example, in this tutorial: (specifically the 6th screen shot)
http://www.geekswithblogs.net/danielggarcia/archive/2013/12/22/portable-databases-ii-using-sqlite-with-entity-framework.aspx

It shows the .Net Data provider for SQLite in the drop down.

Any idea why this wouldn’t be working or what other step I am missing that 
would make this show up there?

Thanks
Sean 

On Apr 24, 2014, at 1:01 PM, Joe Mistachkin  wrote:

> 
> Sean McBride wrote:
>> 
>> I installed the NuGet packages (the one with all 3 modules) into my C#
> project.
>> 
>> I want to import an existing SQLite DB and create a Entity Data Model from
> it.
>> But, when I try to generate from database, the data source and provider do
> not
>> appear in the list.  
>> 
> 
> None of the NuGet packages for System.Data.SQLite install the design-time
> components
> for Visual Studio, since that would require various machine-wide changes.
> 
> --
> Joe Mistachkin
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Provider not showing up in .Net Model import wizard

[Joe Mistachkin]

Sean McBride wrote:
>
> I installed the NuGet packages (the one with all 3 modules) into my C#
project.
> 
> I want to import an existing SQLite DB and create a Entity Data Model from
it.
> But, when I try to generate from database, the data source and provider do
not
> appear in the list.  
> 

None of the NuGet packages for System.Data.SQLite install the design-time
components
for Visual Studio, since that would require various machine-wide changes.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Provider not showing up in .Net Model import wizard

[Sean McBride]

First, I am a long time SQLite user, (first time on .Net).

I installed the NuGet packages (the one with all 3 modules) into my C# project.

I want to import an existing SQLite DB and create a Entity Data Model from it.  
But, when I try to generate from database, the data source and provider do not 
appear in the list.  

I know this is supported because in some tutorials I have found I see screen 
shots where the SQLite Data source appears.

I am using VS 2013.  Did this break in the current version of VS or SQLite 
NuGet packages,? or is there possibly something I am doing wrong?

I haven’t done anything complex.
1.) Create new C# exe.
2.) NuGet the latest SQLite packages
3.) Restart VS and re-open my project (just in case)
4.) Add New Item: ADO.NET Entity Data Model
5.) Choose “Generate from Database”
6.) Click "New connection”
7.) Look for SQLite in the data source list (it isn’t there.  only SQL Server 
items appear in the list)

Thanks in advance!

Sean
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users