ding feature that strongly favor the location of the
System.Data.SQLite assembly itself.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
If you have any issues with the current code, please report them via this
mailing
list (and/or by creating a ticket on "https://system.data.sqlite.org/;)
prior to
this coming Friday, February 7th.
Thanks.
--
Joe Mistachkin
___
sqlite-users ma
Eric Schultz wrote:
>
> The 1.0.91.0 beta you gave me works perfect in my scenario. Thanks so
much!
> Any plan for when the final will be out?
>
The release is currently scheduled for Monday, February 10th (give or take a
day or so).
--
Jo
y have changed. There has been some fairly major feature work
in the last couple releases.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
g
the code base of the assembly (via automatic detection):
https://system.data.sqlite.org/index.html/ci/5ef906e34a
Can you please try these changes in your environment and let us know if they
work for you?
--
Joe Mistachkin
___
sqlite-users mailing li
y supported workaround
for this limitation of Visual Studio is to use the
"PreLoadSQLite_BaseDirectory"
environment variable (or configuration file setting).
Of course, I'm always open to alternative suggestions on how to work around
issues like these in a portable and robust way.
--
J
y packages of
System.Data.SQLite released recently.
As a workaround, you should be able to it build locally using commands
similar to:
CD /D C:\path\to\sqlite\dotnet\Setup
SET NETFX20ONLY=1
CALL build_ce_200x.bat
--
Joe Mistachkin
_
ure the public key token in use matches the one expected by
the application (see above).
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
duce nice results.
Other than that, I'm not sure which profiler I would recommend for managed
code.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
; work with VS.
>
Having it work with Visual Studio during development and on Windows Server
after it has been deployed are two entirely different scenarios.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
er 2012
by
> configuring the AppPool to allow 32 bit execution. I don't understand
that
> either. .dll is located in /Bin folder.
>
There are x64 builds of System.Data.SQLite that should work in a native
64-bit
process on Windows Server.
--
Joe Mistachkin
__
mmbsuc...@charter.net wrote:
>
> Any ideas how to get this to work?
>
Download the version for Visual Studio 2012 and the .NET Framework 4.5
instead. In this case, the file name would be:
https://system.data.sqlite.org/downloads/1.0.90.0/sqlite-netFx45-binary-x64-
2012-1.0.90.0.zi
ficult to
determine without
knowing exactly where the source code used to build your DLL comes from.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
s not appear with the previous
version
of Spatialite.
These statements taken together would seem to indicate that the bug is in
Spatialite,
not System.Data.SQLite.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
ion(IsolationLevel
> isolationLevel)
>at System.Data.SQLite.SQLiteConnection.1/8/2014 3:55 PM
>
That particular exception being thrown by the BeginDbTransaction method
normally
means that the underlying connection is no long
ram with an incorrect
> format.
>
This causes of this error message are covered by the FAQ:
https://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Marcin Szotka wrote:
>
> In my opinion command parameters should use InvariantCulture when
> converting types to string.
>
Support for doing this (via new connection flags) has now been implemented
on trunk, here:
https://system.data.sqlite.org/index.html/info/f2f08c
bably be easier just
to
use the System.Data.SQLite binaries for "PocketPC", seen here under
"Precompiled Binaries for Windows CE (.NET Compact Framework)":
https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
--
Joe Mistachkin
_
mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ed to fix other issues), opening a database on a UNC path requires
that the initial backslashes in the file name be doubled, e.g.:
mypc\db\Mydb.db
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
ht
If you have any issues with the current code, please report them via this
mailing
list (and/or by creating a ticket on "https://system.data.sqlite.org/;)
prior to
next Friday, December 20th.
Thanks.
--
Joe Mistachkin
___
sqlite-users mailing
folder.
>
I'm not sure; however, the "testce" project in the System.Data.SQLite
repository works fine with the standard .NET Compact Framework 2.0.
The project file can be seen here:
https://system.data.sqlite.org/index.html/artifact?ci=trunk=testce/
testce.20
to the possibility of using the wrong database file name.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
oc/trunk/www/news.wiki
In this case, it will be sometime around mid-January, perhaps a bit earlier.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
n be done by right-clicking the "References" node underneath your
project node in the Solution Explorer window and selecting the "Add
reference..."
option.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://
aving
an intermittent issue with query results normally indicates a threading
issue
(e.g. using the same System.Data.SQLite object instance from more than one
thread). Is that a possibility in this case? Can you provide any further
details related to thi
) FROM t1;
>
> (B) How do I make it work for the SQLite System.Data.Sqlite adapter in
.NET?
>
This involves modifying the SQLite.Interop project to include the percentile
extension. The next release (1.0.90.0) will now include this extension by
default.
Vladimir Bradaska wrote:
>
> Namespace System.Data.SQLite.Linq not accessible in Visual Studio 2013
> Express
>
There are no types in the System.Data.SQLite.Linq namespace.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-user
Jan Slodicka wrote:
>
> bool exists;
> exists = idxs.TryGetValue("Abc", out i);// true => ok
> exists = idxs.TryGetValue("abc", out i);// false => BUG
>
Thanks, fixed on trunk. SQLiteDataReader now uses the built-in
StringC
o be entirely compatible, most notable due to not
taking the keyInfo into account.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.
>
I've just checked in files that should assist with properly building things
for Windows Embedded Compact 2013, here:
https://system.data.sqlite.org/index.html/ci/0adcab7b75
Please let us know if these work for you.
--
Joe Mistachkin
___
sq
2008 project into Visual Studio 2012.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Andreas Hofmann wrote:
>
> Anyone know why this is happening?
>
The system might not have the required Visual C++ Runtime Libraries
installed.
However, this can be done manually via one of the downloads at the following
link:
https://support.microsoft.com/kb/2019667
--
Joe M
David Clark wrote:
>
> NMAKE : fatal error U1045: spawn failed : No error
> Stop.
>
>From my research, it looks like this error is caused by a 64-bit versus
32-bit issue. What version Windows are you running? Is it 32-bit or
64-bit? Which ActiveTcl distribution file did you i
ur target processor architecture and .NET Framework version.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Makefile.msc all SPLIT_AMALGAMATION=1
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
m CC'ing you on this reply just in case you are not consistently getting
the list traffic; however, in the future you may wish to check the list
archives to be sure that you did not miss a reply (i.e. because it did not
end up in your inbox, etc).
--
Jo
le does install the required Visual C++
runtime
libraries automatically. That would explain why things worked correctly
after
you ran the setup bundle on the target machine.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqli
ran my
app
> again and it worked as expected.
>
The setup bundle modifies the machine-wide configuration file to add the
SQLite ADO.NET provider. However, when deploying to any machine that does
not
require the Visual Studio design-time functionality, add the necessary
section
to the "
If you have any issues with the current code, please report them via this
mailing
list (and/or by creating a ticket on "https://system.data.sqlite.org/;)
prior to
next Friday, October 25th.
Thanks.
--
Joe Mistachkin
___
sqlite-users mailing
ption
being
thrown, it's very hard to be sure which issue you are encountering.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
uires copying the correct files
into
your application directory. Please see the following:
https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
The sections of interest are: Runtime Library Notes, Using Native Library
Pre-Loading, and Deployment
lections" instead. The columns and data contained in the
> DataTable are correct. This appears to be the only collection with this
> problem.
>
Thanks for the report. Fixed now:
https://system.data.sqlite.org/index.html/ci/e1c3a2bc9c?sbs=0
--
Joe Mistachkin
__
Jan Nijtmans wrote:
>
> Well, I did some digging as well, and it looks like the libtool upgrade
> is the coolpit:
>
> See:<http://www.sourceware.org/autobook/autobook/autobook_88.html>
>
Thanks a lot for looking into
t us in the
direction of which symbols are "undefined"?
>
> If new declarations sans definitions weren't actually added, perhaps
> someone forgot to add:
>
> #ifdef _WIN32
> __declspec(dllexport)
> #endif
>
It looks like you are compiling the am
re are two applications accessing the database.
Which one are you having to kill? Do you have any sample code which would
help us identify the problem? What version of SQLite is being used?
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.o
e temporary directory to a location where your
application has read-write permissions?
What result do you get for "PRAGMA temp_store_directory;" ?
Are you able to install a sqlite3_log callback (via sqlite3_config)
and see more details about the error message you
rectory() being executed prior to opening
the database and is it returning SQLITE_OK?
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
h to try using the latest released version
of
System.Data.SQLite.
Alternatively, you might want to look into the commercial SEE extension,
which does
work with System.Data.SQLite and is fully supported for use with it.
--
Joe Mistachkin
___
sqlite-users mailing list
those an throw an exception?
>
> Note:
> SqliteParameterCollection.IsSynchronized should return false
Thanks for the report. Fixed here:
https://system.data.sqlite.org/index.html/ci/7a1efd7d40?sbs=0
--
Joe Mistachkin
___
sqlite-users m
on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
If you have any issues with the current code, please report them via this
mailing
list (and/or by creating a ticket on "https://system.data.sqlite.org/;)
prior to
next Friday, August 2nd.
Thanks.
--
Joe Mistachkin
___
sqlite-users mailing list
s
4A7DDA9FDB321459F');
> 1|integer
> 01 01|text
> sqlite>
>
> I *expected* to gain TEXT affinity through the use of System.Data.SQLite
and it's strongly typed types (doppelt
> gemoppelt?), but apparently this is not totally effective. Maybe Joe
Mistachkin can say som
on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ntion.
Thanks.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
me2 is not recognized by System.Data.SQLite.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
DateTimeFormat=CurrentCulture;DateTimeKind=Utc;DateTimeFormat
String=M/d/ h:mm:ss tt;"
>
> Would I need to download a new .NET API or Sqlite version?
>
Yes, the code is only available in the Fossil source code repository at the
moment.
--
Joe Mistachkin
__
e some additional troubleshooting steps
you
can take to determine EXACTLY how parameter values are being bound to your
statement (e.g. via the LogBind connection flag, which can also be enabled
via
the connection string). The documentation contains full details on the
possible
connection flag
control over the exact format string that will be used
to parse and format DateTime objects for a particular connection. Perhaps
this will assist with your issue? The changes can be seen here:
https://system.data.sqlite.org/index.html/info/4f933521a1
--
Jo
mpatible way.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
"-MM-ddTHH:mm:ss",
"MMddHHmmss",
"MMddHHmm",
"MMddTHHmmssFFF",
"-MM-dd",
"MMdd",
"yy-MM-dd"
};
The DateTime.ParseExact method is used by System.Data.SQLite; therefore, if
the
DateTime string does not conform to one of the above formats, an exception
will
be generated.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ons are statically linked, things may work fine. However,
running inside the WinRT sandbox will introduce some complications for
dynamic loading, see:
http://msdn.microsoft.com/en-us/library/windows/desktop/hh447159%28v=vs.85%2
9.aspx
--
Joe Mistachkin
__
FILEMAPPING_API=1"
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
NSDKLIBPATH=%ProgramFiles(x86)%\Windows Phone Kits\8.0\lib\x86
nmake -f Makefile.msc sqlite3.dll FOR_WINRT=1 USE_RC=0
OPTS="-DWINAPI_FAMILY=WINAPI_FAMILY_PHONE_APP -DSQLITE_OMIT_LOAD_EXTENSION=1
-DSQLITE_WIN32_FILEMAPPING_API=1&quo
/index.html/doc/trunk/www/downloads.wiki
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
system.data.sqlite.org/index.html/info/dcc277f29a
It will be present in the next release (1.0.86.0), due out shortly.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
om extension:
http://maia.usno.navy.mil/ser7/tai-utc.dat
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Lite.
In theory, this could pose a problem: If you actually intend to use
partially trusted assemblies -OR- if you intend to install the
System.Data.SQLite assemblies into a shared location on the machine,
such as the GAC.
Perhaps the attribute should be removed from System.Dat
oming release):
https://system.data.sqlite.org/index.html/info/49e30d7612
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e in Windows Explorer,
right-click the
file, go to "Properties", and then click the "Unblock" button.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Levi Haskell wrote:
>
> Is this what the INTEROP_LEGACY_CLOSE compile-time option refers to?
>
Yes.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
st-practices for the IDisposable interface, and relied heavily upon
internal
semantics of the native SQLite core library.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
// the following line succeeds in v1.0.81.0 and earlier but
> // FAILS on v1.0.82.0 and later with "file still in use" error
> File.Delete(file);
>
In the above example, adding "command.Dispose();" just prior to the end of
the using block should allow th
hese requirements in each applicable
download
package section; however, perhaps there should be a more prominent notice on
the top of the download page?
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
to the Global Assembly
Cache and this may not always be desirable. Unfortunately, this is a
requirement that Visual Studio appears to impose on managed assemblies
referenced by an installed package.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlit
If you have any issues with the current code, please report them via this
mailing
list (and/or by creating a ticket on "https://system.data.sqlite.org/;)
prior to
this Friday, April 12th.
Thanks.
--
Joe Mistachkin
___
sqlite-users mailing list
s
ip" download
package are intended to be used with the .NET Compact Framework 3.5 running
on an ARM processor.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
test version you have suggested might need .net CF 3.5 but I must
use
> 2.0 CF.
>
It is also possible to target the .NET Compact Framework 2.0 with the
current
sources by using the project file for Visual Studio 2005.
--
Joe Mistachkin
___
sqlite
indows-store-apps.aspx
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
when any event calls sqlite dll it is
raising
> errors.
>
What errors does it raise?
>
> I am using SQLite-1.0.66.0-binaries.
>
Have you tried using the latest version? It is available from:
http://system.data.sqlite.org/downloads/1.0.84.0/sqlite-netFx35-binary-Pocke
Mason, Philip wrote:
>
> OK ... I've done this and verified that the database file gets released
> appropriately when running my test code with EF5.
>
Thanks. The changes have now been merged to trunk and will appear in the
next
release.
--
Jo
needs to be set to "true" and the define "INTEROP_LEGACY_CLOSE=1;"
needs to
be added to the INTEROP_EXTRA_DEFINES property in the
SQLite.Interop.20XX.[vs]props
file for the version of Visual Studio being used.
--
Joe Mistachkin
___
sqli
would be to
compile
it with the new compile-time option INTEROP_LEGACY_CLOSE enabled:
https://system.data.sqlite.org/index.html/timeline?r=legacyClose
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
:
http://www.mail-archive.com/sqlite-users%40sqlite.org/msg74770.html
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
wrappers available
for SQLite for Windows Phone 8. Some possible options are:
https://www.nuget.org/packages/sqlite-net
http://sqlwinrt.codeplex.com/
Also see Tim Heuer's blog for more information:
http://timheuer.com/blog/
--
Joe Mistachkin
al access violations, etc; now, it just
keeps the database connection handle active until everything has
been properly disposed.
>
> 2) Do Entity Framework team members read this list?
>
I don't know.
--
Joe Mistachkin
___
sqlite-users mailing
er. Also,
even the DbCommand base class provided by the .NET Framework itself
implements
IDisposable (i.e. the class used as the base class for SQLiteCommand).
Perhaps somebody on the Entity Framework team could shed some extra light on
this issue?
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
mplementation
detail.
http://msdn.microsoft.com/en-us/library/system.data.idbtransaction.connectio
n.aspx
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
and
line. Here is an example:
nmake /f Makefile.msc sqlite3.dll FOR_WINRT=1
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Michael Russell wrote:
>
> I did do a check-out after you made the above suggestion to me. I did the
> fossil checkout / build, but I still have the same problem.
>
Is there any way you can determine which System.Data.SQLite objects are
being
held open by the Entity Framew
/www.sqlite.org/src/timeline?r=trunk
> . Is there a build somewhere? I would be happy to try it.
>
The check-in I mentioned is here:
https://system.data.sqlite.org/index.html/info/42d873a6d8
I'm doing the release build for 1.0.84.0 right now; however, it will not
be ready until
us know if that clears
the
issue you are seeing?
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
one or more
System.Data.SQLite objects have not been disposed and it's holding the
database connection and it's associated file(s) open.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
tion open. I'm not sure if there is a way to force it to close the
connection and/or dispose of the other System.Data.SQLite resources it's
using.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/
sqlCommand = new SQLiteCommand(connection)
> {
> CommandText = "SELECT * from User where Username='administrator'"
> };
>
If you make sure and dispose of all SQLiteCommand and SQLiteDataReader
objects
associated with a particular connecti
be used instead.
Alternatively, the IsDBNull method may be called to check if the underlying
column
value is NULL prior to calling one of the strongly typed methods.
However, I'm not sure how to get the Entity Framework to do that.
--
Joe Mistachkin
___
sqlite-use
State.
>
For your code to be robust using release 1.0.82.0 or later, you'll want to
execute a command (any command that reads the schema will work) against the
connection prior to considering the password as "correct".
--
Joe Mistachkin
___
s
301 - 400 of 659 matches
Mail list logo