Re: [sqlite] [EXTERNAL] Re: Question about: Adding a record to a table with select failure

[Hick Gunter]

Nothing. The select returns no rows so no rows are inserted.

-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im 
Auftrag von Doug
Gesendet: Freitag, 15. November 2019 17:42
An: 'SQLite mailing list' 
Betreff: [EXTERNAL] Re: [sqlite] Question about: Adding a record to a table 
with select failure

WRT Jose's original context, and just for my enlightment, what happens with the 
following:

insert into t (a, b, c, d, e, idate)
SELECT a, b, c, 'y', e, '2019-02-12' FROM t WHERE a = 'p999';

where p999 does not define a record? Is a new record inserted with values of 
a,b,c, and e null?

> -Original Message-
> From: sqlite-users 
> On Behalf Of Jose Isaias Cabrera
> Sent: Friday, November 15, 2019 6:21 AM
> To: SQLite mailing list 
> Subject: Re: [sqlite] Adding a record to a table with one value change
>
>
> Simon Slavin, on Thursday, November 14, 2019 06:48 PM, wrote...
> >
> > On 14 Nov 2019, at 10:27pm, Jake Thaw, on
> >
> > > Why not like this?
> > >
> > > insert into t (a, b, c, d, e, idate) SELECT a, b, c, 'y', e,
> > > '2019-02-12' FROM t WHERE a = 'p001'
> ORDER BY
> > > idate desc limit 1;
> >
> > Dammit.  I thought I had tried this, and received a syntax
> error.  Now I see that it was because I missed out a comma.
> Thanks for the correction.
>
> That just lets you know that you are a human. ;-)
>
> > Good illustration of why responses should go to the list rather
> than direct to the OP.
>
> Indeed.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-
> users

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


___
 Gunter Hick | Software Engineer | Scientific Games International GmbH | 
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 
1 80100 - 0

May be privileged. May be confidential. Please delete if not the addressee.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Entity Framework Core support

[Joe Mistachkin]

Mike King wrote:
>
> "It needs to be clearly stated somewhere that EF 6.3 is meant only as a
> tool for migrating from .NET Framework, and that EF Core is the version
> that should be used." *2
> 

Given the phrasing here, it sounds like this guidance is relatively new
and/or unofficial at this point?

> 
> . But
> because it's a new code base, it also lacks some features that EF6 has."
*3
> 

To clarify, if it lacks features that EF6 has, it sounds a lot less like
a porting effort and a lot more like a rewriting effort.  That does not
necessarily mean it won't get done (at some point); however, that will
certainly impact it's relative priority on the roadmap.

--
Joe Mistachkin

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

Re: [sqlite] Deployment question

[Joe Mistachkin]

Les Woolsey wrote:
>
> 1. I deployed the app with the DLL's I had downloaded and the X86 & x64
>folders from the zip file.  Still doesn't work.
> 

This will not work.  The "System.Data.SQLite.dll" managed DLL files are
compiled with different options that dictate how it integrates with the
native library code.

> 
> 2. Deployed the app with the system.data.sqlite.dll file I have installed
>but with the ef6 & Linq dll's  & folders from your zip - Still doesn't
>work
> 

This also won't work, for the same reason as #1.

>
> 3. Deployed the app with the dlls from your zip and the folders - still
>doesn't work.
> 

What is the target operating system?  Was there an error message?

> 
> 4. As I said I my last email, I tried to rebuild my app after refoming
>the reference to my system.data.sqlite and replacing it with a
>reference you the one from the zip.  It doesn't compile but gives
>errors that SQLite does not exist in > the namespace system.data.
>(Also goves further errors that derive from that problem).
> 

I would suggest double-checking the "Target framework" setting for the
project(s) on the "Application" tab within their project properties.

For the set of DLLs from the new download, you'll want to make sure
they are all set to .NET Framework 4.6.

--
Joe Mistachkin

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

Re: [sqlite] Deployment question

[Les Woolsey]

You didn't get back to me with an answer so I went ahead and tried a few 
options.  
1. I deployed the app with the DLL's I had downloaded and the X86 & x64 folders 
from the zip file.  Still doesn't work.
2. Deployed the app with the system.data.sqlite.dll file I have installed but 
with the ef6 & Linq dll's  & folders from your zip - Still doesn't work
3. Deployed the app with the dlls from your zip and the folders - still doesn't 
work.
4. As I said I my last email, I tried to rebuild my app after refoming the 
reference to my system.data.sqlite and replacing it with a reference you the 
one from the zip.  It doesn't compile but gives errors that SQLite does not 
exist in the namespace system.data. (Also goves further errors that derive from 
that problem).

I would guess that I can't mix and match. If I want to use the 
system.data.sqlite from the zip file you recommended that I have to compile 
with it and deploy with it.  But it wont compile!  Is there some setting I need 
to make in the project? Are those dll's bad?

I appreciate your time.  What do I try now?

Thanks
Les

-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On 
Behalf Of Joe Mistachkin
Sent: Saturday, November 16, 2019 3:38 PM
To: 'SQLite mailing list'
Subject: Re: [sqlite] Deployment question


Les Woolsey wrote:
>
> I installed a setup package for X64 from the download page. 
> (sqlite-netFx45-setup-bundle-x64-2012-1.0.112.0.exe)
>

Thanks, I understand the situation now.  Please use the files
from the following download instead:

https://system.data.sqlite.org/downloads/1.0.112.0/sqlite-netFx46-static-bin
ary-app-2015-1.0.112.0.zip

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

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

Re: [sqlite] Entity Framework Core support

[Mike King]

"The EF team is now focused on the EF Core 3.1 release, which is planned
for later this year, and on making sure that the documentation for EF Core
3.0 is complete." *1

"It needs to be clearly stated somewhere that EF 6.3 is meant only as a
tool for migrating from .NET Framework, and that EF Core is the version
that should be used." *2

"EF6 continues to be a supported product, and will continue to see bug
fixes and minor improvements." *3
"EF Core offers new features that won't be implemented in EF6 (such as
alternate
keys , batch
updates
,
and mixed client/database evaluation in LINQ queries
. But
because it's a new code base, it also lacks some features that EF6 has." *3

EF6 is going to be legacy, the best practice is now to use EFCore for new
projects. Is this something which you should be considering putting in your
roadmap?

Thanks,

Mike

sources:

*1
https://devblogs.microsoft.com/dotnet/announcing-ef-core-3-0-and-ef-6-3-general-availability/
*2 https://github.com/aspnet/EntityFramework6/issues/834
*3 https://docs.microsoft.com/en-us/ef/efcore-and-ef6/



On Sun, 17 Nov 2019 at 23:08, Joe Mistachkin  wrote:

>
> Mike King wrote:
> >
> > Sorry to chase an answer but is there any plans to support Entity
> Framework
> > Core in the roadmap? As I understand it the current version of EF6 is
> > probably going to be the last and it's likely that MS is going to
> recommend
> > people move over to Core.
> >
>
> Given that Entity Framework 6.3.0 was released quite recently (with .NET
> Core
> support), it seems that it should be around for a while longer.
>
> Currently, there are no specific plans to support Entity Framework Core in
> System.Data.SQLite.
>
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Entity Framework Core support

[Joe Mistachkin]

Mike King wrote:
>
> Sorry to chase an answer but is there any plans to support Entity
Framework
> Core in the roadmap? As I understand it the current version of EF6 is
> probably going to be the last and it's likely that MS is going to
recommend
> people move over to Core. 
> 

Given that Entity Framework 6.3.0 was released quite recently (with .NET
Core
support), it seems that it should be around for a while longer.

Currently, there are no specific plans to support Entity Framework Core in
System.Data.SQLite.

--
Joe Mistachkin

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

Re: [sqlite] Entity Framework Core support

[Mike King]

Hi,

Sorry to chase an answer but is there any plans to support Entity Framework
Core in the roadmap? As I understand it the current version of EF6 is
probably going to be the last and it's likely that MS is going to recommend
people move over to Core.

Cheers,

Mike

On Fri, 15 Nov 2019 at 00:02, Mike King  wrote:

> Hi All,
>
> I can see System.Data.Sqlite supports Entity Framework 6. Are there any
> plans to support Entity Framework Core?
>
> Apologies if this is a basic question!
>
> Cheers,
>
> Mike
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users