Re: Entity Framework Provider for i

I understand entity framework to be the thing that takes the SQL out of
database access. Where your code calls methods in classes that the EDMX
created to read and write to the database.
here is some code that calls into EF classes to write a row to a database
table:

software_mainEntities _db = new software_mainEntities();

var userSystem = new UserSystem()
{
UserId = userRow.UserId,
SerialNbr = Form["SerialNbr"].TrimWhitespace(),
LicenseKey = Form["LicenseKey"].TrimWhitespace(),
ModelText = Form["ModelText"].TrimWhitespace( ),
OsRelease = Form["OsRelease"].TrimWhitespace( )
};

if (ModelState.IsValid)
{
_db.AddToUserSystems(userSystem);
_db.SaveChanges();
return RedirectToAction("AccountMaint");
}


On Wed, Jun 15, 2011 at 9:50 AM, Mike Wills <mike@xxxxxxxxxxxx> wrote:

I want to add the table to a .edmx file (Entity Framework in VS2010).
At least that is my understanding to enable this. I want to do this so
I don't have to write the specific queries that I need and fill the
object every time.

Here's a sample of what I do now:
https://gist.github.com/f48d2138b5ad6fcb2131

After the object is created, it is simple to move data around and do
some basic sorting and filtering in the object itself without SQL.

Probably should write a full article on this. This works well within
the ASP.NET MVC framework.

--
Mike Wills
http://mikewills.me



On Tue, Jun 14, 2011 at 12:03 PM, Richard Schoen
<richard@xxxxxxxxxxxxxxx> wrote:

Mike,

Can you provide steps for what you're trying ?

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business

Intelligence

Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

------------------------------

message: 4
date: Mon, 13 Jun 2011 15:01:05 -0500
from: Mike Wills <mike@xxxxxxxxxxxx>
subject: Re: [SystemiDotNet] Entity Framework Provider for i

IBM FAIL! It may be a .NET 2.0 driver, but it still doesn't show up in

the various drop downs. I have yet to install the Client Access 7.1 drivers.
Those will be next.

--
Mike Wills
http://mikewills.me


--
This is the .net use with the System i (SystemiDotNet) mailing list
To post a message email: SystemiDotNet@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/systemidotnet
or email: SystemiDotNet-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/systemidotnet.

--
This is the .net use with the System i (SystemiDotNet) mailing list
To post a message email: SystemiDotNet@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/systemidotnet
or email: SystemiDotNet-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/systemidotnet.