|
I have an older vb win app that I wrote in VS2013 because I have install shield that supports it. I used LocalDB for the database and it worked fine. But LocalDB is pretty heavy, I had to write an automated script to install it first, and then used old school TSQL to make the calls.
So the customer asked me to upgrade it, make it more modern. I choose SQLite, but EF6 doesn't support migrations or table creation. I really don't want to write older code to support it. Now I'm looking for something else to use. Would like to use MongoDB but them I have to wrote code to install it first which may be easier than using SQLite.
On .Net Core, SQLite works great, and I heard some .Net Core features will be available for win apps.
Any Suggestions?
If it ain't broke don't fix it
Discover my world at jkirkerx.com
|
|
|
|
|
LiteDB is a no-install object store for .NET. It's effectively a no-install Mongo.
I've used it for relatively small-scale applications with success (relatively few collections, up to a few hundred thousand records per collection).
Mind you, object stores are not necessarily the right answer if the data is heavily relational; you might want to stick with LocalDB and optimize your queries.
"Never attribute to malice that which can be explained by stupidity."
- Hanlon's Razor
|
|
|
|
|
I'll take a look at that.
I just have 4 tables that store account names, manufactures and product with a join to pricing.
About 500 products, and pricing for every product and account. So the pricing may grow large.
If it ain't broke don't fix it
Discover my world at jkirkerx.com
|
|
|
|
|
Both VB and C# contain a way of testing mutually exclusive possibilities, the Select Case and Switch clauses respectively. Only one of them works properly.
A Visual Basic Select Case clause, returning a description of how old someone is. The age range for a young person is a tad generous, reflecting the age of the author of this article.
|
|
|
|
|
Hi,
I have taken a backup of one Database DBa, then I created a new Database that's DBb, I tried to restore the Database DBb, message says Database restored successfully but still the new DBb doesn't get any Tables, Views or SPs in to this new Database DBb.
When I am taking the backup options that I have taken are as below:
in General tab, 1. Backup Type: Full 2. Copy only Backup in Options tab: 1. Backup set will expire: I have taken more than 1000 or 100 max number
In the restore I have taken the options of:
Restore -> Database in that In General Tab: Selected "Device" then selected the file
In Options tab: 1. Overwrite existing Database 2. Close existing connections.
Then OK,
Is there any mistake I did either in taking the backup or in restoring the Db, but the message says, the Database is restored successfully but restore doesn't create any tables views or any object of the backup file, I am not understanding, any help would be greatly helpful, please, the message is so misleading for me. Thanks in advance
modified 8-Nov-18 12:35pm.
|
|
|
|
|
Hello,
I have a column in table that have nvarchar(200) datatype
and then I add index on another column include my nvarchar(200) column
but the performance is the same when I do a select query with where condition in the nvarchar(200) column
I need to know why the index on nvarchar column doesn't affect the performance?
|
|
|
|
|
|
IS there any explanation for this ?
|
|
|
|
|
|
Message Removed
modified 9-Nov-18 11:29am.
|
|
|
|
|
hi
please help me i have a project, need to write a code in ms access or python to do the able to press a button on the form windscreen that scans an image into my database field.
|
|
|
|
|
|
Have you contacted the manufacturer of said scanner and asked them how to interact with it programmatically? Probably through an API that they would have to provide.
As things stand, I could probably tell you how to interact with my old scanner - but you can bet your bottom dollar it won't work for yours. So more detail would be needed.
As an aside, storing the actual scanned image onto your "database field" is probably going to be a very bad idea. The Access file is going to get very big very quickly. You should consider storing the image on the file system (it's what it is designed for) and storing a link to it on the database itself (hint - using explicit paths or drive mappings is not a good idea - a rather bitter experience with FileNet proved this to me in the past)
|
|
|
|
|
the database program consith of the following fields
Name
Surname
Scanned document of The Person
Please help i am new to programming i do not want to loose hope!
|
|
|
|
|
Quote: Have you contacted the manufacturer of said scanner and asked them how to interact with it programmatically? Probably through an API that they would have to provide.
If you are new to programming then getting a scanner to work through an API is probably beyond your current capabilities.
Your table (it is not a database) should also include a unique identifier for the person (after all, people can have the same name).
Do not store the actual document on the database, store it's relative path or it's path relative to a fixed folder name.
|
|
|
|
|
HI
I NEED HELP IN TRYING TO WRITE DATABSE PROGRAM TO IN ACCESS OR PYTHON CAPTURE THE NAME, ID NUMBER, ADDRESS, PHONE NUMBER, AND FIELD TO ABLE TO SCAN DOCUMENT TO FROM A FLAT BED SCANNER TO MY ACCESS DATABSE FIELD.
WHEN I PRESS A BUTTON ON THE FORM. I AM STILL LEARNING PYTHON AND ACCESS
PLEASE HELP 
|
|
|
|
|
|
Scenario:
one User1 press the save gets the last number 1000012 on the header then Run SP for Details saving(with 3 detail line items)
at the same time user2 press the save gets 1000013 on the header then Run SP for Details saving
(with 1 detail line items)
after checking after checking users inserted
user1 has 4 lines
user2 has 0 lines
ALTER PROCEDURE [dbo].[sp_HeaderSave] (@Lastnumber Decimal) AS
BEGIN
INSERT INTO Header (DOCNo, VersionNo, NoteDate)
VALUES (@Lastnumber,'VersionNo',GETDATE())
END
ALTER PROCEDURE [dbo].[sp_DetailSave] (@Lastnumber Decimal) AS
BEGIN
INSERT INTO Detail(DOCNo, ItemNo, Qty)
VALUES (@Lastnumber,'Items One',12)
END
thank you,
|
|
|
|
|
|
i tired this, how can i pass the @lastnumber it came from other table? 
CREATE TABLE ControlNumbers (
LastNumber Varchar(50)
)
|
|
|
|
|
Hotaxion wrote: CREATE TABLE ControlNumbers (
LastNumber Varchar(50)
)
Interesting! In your OP you declared LastNumber as "Decimal". Now you show some other LastNumber which is in this case Varchar(50).
Are these two different? Or which type is correct?
And why not use the int with Identity? Something like:
CREATE TABLE ControlNumbers (
LastNumber Int IDENTITY(1,1)
)
|
|
|
|
|
the front end of the application is returning last number and saving it like this "M01-00002" on the Table i get the Right(lastnumber,5) then Plus 1 ty
|
|
|
|
|
As I said, either use an IDENTITY column, or use a SEQUENCE.
A varchar column can't automatically generate new values.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
the scenario is i can't modified/change the Table datatype coz other application is using it.. lets say the table is on our ERP.
|
|
|
|
|
Another technique is to have another table that just generates the ids for you
CREATE TABLE IdsList(id INT IDENTITY(1,1), datum CHAR(1));
In your (single) stored procedure first do this
INSERT #IdsList(datum) VALUES('x');
declare @lastnum int = (SELECT SCOPE_IDENTITY())I would also suggest putting your stuff into a single SP and wrapping it all up in a transaction
ALTER PROCEDURE [dbo].[sp_HeaderSave] (@Lastnumber int OUTPUT) AS
BEGIN
BEGIN TRANSACTION [MyTrans]
BEGIN TRY
INSERT #IdsList(datum) VALUES('x');
SET @lastnumber int = (SELECT SCOPE_IDENTITY())
INSERT INTO Header (DOCNo, VersionNo, NoteDate)
VALUES (@Lastnumber,'VersionNo',GETDATE())
COMMIT TRANSACTION [MyTran]
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION [MyTran]
END CATCH
END
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
