Re: LINQ providers

[Greg Keogh]

>
> I assume that the ISAM data file system is a pre-requisite?
> We use an ISAM file system as well and the platform supplier has provided
> a LINQ provider for us - no such luck with your ISAM provider?
>

It's actually this library from Microsoft:

http://managedesent.codeplex.com/wikipage?title=ManagedEsentDocumentation&referringTitle=Documentation

I just noticed they've added basic LINQ support to the accompanying
PersistentDictionary

class (which I don't use), so I downloaded the source for a look about how
it was done ... I can tell you immediately that unless you have some
experience with this sort of coding that it will look like gibberish.

*Greg*

Re: PDF and .doc generators for websites

[eddie.debear]

Hi Greg,


I worked with the Open XML SDK a few years back, to produce some large 
documents (a few hundred pages at a time). I don’t know if it’s improved since 
then, but it was a fairly bare-bones thing back then. Despite that, it worked, 
and worked well.


As for Pdf, I’ve worked with both Aspose.Pdf and isharptext. Both work well, 
are fast and are easy to work with.


Ed.






Sent from Windows Mail





From: William Luu
Sent: ‎Wednesday‎, ‎22‎ ‎October‎ ‎2014 ‎4‎:‎24‎ ‎PM
To: ozDotNet






Hi Greg,




Another option is Open XML SDK for Office docs.



https://github.com/OfficeDev/Open-XML-SDK 
http://msdn.microsoft.com/en-us/library/office/bb448854.aspx





Andrew Coates did a session on it at Tech Ed.




Cheers,




Will






On 22 October 2014 15:14, Grant Maw  wrote:


I've been using ABCPDF for years in a Webforms environment. It's worked very 
well, it's fast and does everything we need it to do.






On 22 October 2014 13:43, Greg Low (低格雷格)  wrote:




Hi Folks,

 

Anyone got strong opinions on particular PDF and .doc generators for use with 
MVC ?

 

Regards,

 

Greg

 

Dr Greg Low

 

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax 

SQL Down Under | Web: www.sqldownunder.com

Re: PDF and .doc generators for websites

[William Luu]

Hi Greg,

Another option is Open XML SDK for Office docs.

https://github.com/OfficeDev/Open-XML-SDK
http://msdn.microsoft.com/en-us/library/office/bb448854.aspx

Andrew Coates did a session on it at Tech Ed.

Cheers,

Will


On 22 October 2014 15:14, Grant Maw  wrote:

> I've been using ABCPDF for years in a Webforms environment. It's worked
> very well, it's fast and does everything we need it to do.
>
> On 22 October 2014 13:43, Greg Low (低格雷格)  wrote:
>
>>  Hi Folks,
>>
>>
>>
>> Anyone got strong opinions on particular PDF and .doc generators for use
>> with MVC ?
>>
>>
>>
>> Regards,
>>
>>
>>
>> Greg
>>
>>
>>
>> Dr Greg Low
>>
>>
>>
>> 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913
>> fax
>>
>> SQL Down Under | Web: www.sqldownunder.com
>>
>>
>>
>
>

Re: PDF and .doc generators for websites

[Grant Maw]

I've been using ABCPDF for years in a Webforms environment. It's worked
very well, it's fast and does everything we need it to do.

On 22 October 2014 13:43, Greg Low (低格雷格)  wrote:

>  Hi Folks,
>
>
>
> Anyone got strong opinions on particular PDF and .doc generators for use
> with MVC ?
>
>
>
> Regards,
>
>
>
> Greg
>
>
>
> Dr Greg Low
>
>
>
> 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913
> fax
>
> SQL Down Under | Web: www.sqldownunder.com
>
>
>

Re: PDF and .doc generators for websites

[Les Hughes]

I've used Aspose.NET in the past, and while it is pricey compared to
some others, it works fantastically.

Cheers :)
--
Les Hughes
l...@datarev.com.au

On 22/10/14 14:43, Greg Low (低格雷格) wrote:
> Hi Folks,
> 
> Anyone got strong opinions on particular PDF and .doc generators for use 
> with MVC ?
> 
> Regards,
> 
> Greg
> 
> Dr Greg Low
> 
> 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 
> fax
> 
> SQL Down Under| Web: www.sqldownunder.com 
> 

RE: PDF and .doc generators for websites

[低格雷格]

Hi Stephen,

Site I’m at this week is using ABCpdf and I’m wondering about experiences with 
it or other options. I’ve got an upcoming project that I need to do it myself, 
and need to generate .doc/.docx files as well. I had wondered about the Aspose 
options too.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Stephen Price
Sent: Wednesday, 22 October 2014 2:46 PM
To: ozDotNet
Subject: Re: PDF and .doc generators for websites

I had a look at this briefly, there seemed to be a couple of options of doing 
it in code. I think some paid, and some open source (nuget packages).
I didn't end up going with it in the end, I decided for now to just let the 
user print to PDF using built in Windows if they wanted to. :)

I'd like it but its down the list of features...
would be interested in hearing how you go in your own PDF adventure, so let us 
know what you find yourself.

cheers
Stephen


+61 (0) 428 028 599
step...@lythixdesigns.com
@lythixdesigns | @lyynx
www.lythixdesigns.com
www.linkedin.com/in/lyynx

On Wed, Oct 22, 2014 at 11:43 AM, Greg Low (低格雷格) 
mailto:g...@greglow.com>> wrote:
Hi Folks,

Anyone got strong opinions on particular PDF and .doc generators for use with 
MVC ?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ 
+61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com

RE: PDF and .doc generators for websites

[Grant Castner]

Hi Greg,

For pdf, we use EO.pdf (

http://www.essentialobjects.com/Products/Pdf/Default.aspx). We've been using
it for a couple of years now and it has gone well.

 

Cheers,

Grant

 

Dr Grant Castner

  gcast...@outlook.com.au

0458 770 749

  https://twitter.com/grantcastner

 
http://www.linkedin.com/pub/grant-castner/0/415/bb2 

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Low ()
Sent: Wednesday, 22 October 2014 1:43 PM
To: ozDotNet
Subject: PDF and .doc generators for websites

 

Hi Folks,

 

Anyone got strong opinions on particular PDF and .doc generators for use
with MVC ?

 

Regards,

 

Greg

 

Dr Greg Low

 

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax


SQL Down Under | Web:   www.sqldownunder.com

 

Re: PDF and .doc generators for websites

[Stephen Price]

I had a look at this briefly, there seemed to be a couple of options of
doing it in code. I think some paid, and some open source (nuget packages).
I didn't end up going with it in the end, I decided for now to just let the
user print to PDF using built in Windows if they wanted to. :)

I'd like it but its down the list of features...
would be interested in hearing how you go in your own PDF adventure, so let
us know what you find yourself.

cheers
Stephen


+61 (0) 428 028 599
step...@lythixdesigns.com
@lythixdesigns | @lyynx
www.lythixdesigns.com
www.linkedin.com/in/lyynx

On Wed, Oct 22, 2014 at 11:43 AM, Greg Low (低格雷格)  wrote:

>  Hi Folks,
>
>
>
> Anyone got strong opinions on particular PDF and .doc generators for use
> with MVC ?
>
>
>
> Regards,
>
>
>
> Greg
>
>
>
> Dr Greg Low
>
>
>
> 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913
> fax
>
> SQL Down Under | Web: www.sqldownunder.com
>
>
>

PDF and .doc generators for websites

[低格雷格]

Hi Folks,

Anyone got strong opinions on particular PDF and .doc generators for use with 
MVC ?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com

Re: LINQ providers

[Steven Parish]

Hi Greg,

I assume that the ISAM data file system is a pre-requisite?

We use an ISAM file system as well and the platform supplier has provided a
LINQ provider for us - no such luck with your ISAM provider?

*Regards,*



*Steven Parish*

*Managing Director*


 *BusinessCraft Pty Ltd*

*Address:* Level 1, 270 Turton Road, New Lambton NSW 2305

*Mail:* PO Box 57, Lambton NSW 2299

*M:* 0417 688 599 | *T:* 02 4965  | *F:* 02 4965 5333

*www.businesscraft.com.au *

On 22 October 2014 10:14, Greg Keogh  wrote:

> Folks, I have a simple ISAM data source which can get-by-key or seek on
> arbitrary indexes. I'm only using an Int32 primary key at the moment and
> haven't needed to create more indexes so far. For a few thousand records
> the performance is good, but as it grows and you ask for something like
> this:
>
> var smiths = mydb.List().Where(c => c.Surname =
> "Smith").OrderBy(c => c.Postcode);
>
> It slows because this query inefficiently "Lists" the complete database
> over the primary Int32 index and then uses LINQ-to-objects to give me the
> result. In this case it's no better than reading a txt file.
>
> I realised of course that the real solution is to make my data source a
> LINQ Provider that it can use its internal DB smarts to answer queries
> efficiently. By looking at these articles: *Walkthrough: Creating an
> IQueryable LINQ Provider
> *
> and *Enabling a Data Source for LINQ Querying
> * I realised I was
> up for a full-time specialist job for a few months. The latter page
> describes how you can decide to make a *simple*, *medium* or *complex*
> provider and it warns: "Developing a complex provider requires a
> significant amount of effort". After reading about expression trees I
> realise this is a highly specialised and complex topic. Even Oren who
> created RavenDB says it took him longer to write the LINQ provider for the
> database than it took to write the database itself, which is pretty
> sobering!
>
> I'd still like to turn my data source into a *simple* LINQ provider if
> possible, but lord knows where to start, maybe at the huge walkthrough in
> my first link. I found re-linq  which
> apparently takes some of the pain of working with expression trees, but I
> haven't even found a tutorial on it yet.
>
> Has anyone got experience or comments on this subject?
>
> *Greg K*
>

LINQ providers

[Greg Keogh]

Folks, I have a simple ISAM data source which can get-by-key or seek on
arbitrary indexes. I'm only using an Int32 primary key at the moment and
haven't needed to create more indexes so far. For a few thousand records
the performance is good, but as it grows and you ask for something like
this:

var smiths = mydb.List().Where(c => c.Surname =
"Smith").OrderBy(c => c.Postcode);

It slows because this query inefficiently "Lists" the complete database
over the primary Int32 index and then uses LINQ-to-objects to give me the
result. In this case it's no better than reading a txt file.

I realised of course that the real solution is to make my data source a
LINQ Provider that it can use its internal DB smarts to answer queries
efficiently. By looking at these articles: *Walkthrough: Creating an
IQueryable LINQ Provider
*
and *Enabling a Data Source for LINQ Querying
* I realised I was
up for a full-time specialist job for a few months. The latter page
describes how you can decide to make a *simple*, *medium* or *complex*
provider and it warns: "Developing a complex provider requires a
significant amount of effort". After reading about expression trees I
realise this is a highly specialised and complex topic. Even Oren who
created RavenDB says it took him longer to write the LINQ provider for the
database than it took to write the database itself, which is pretty
sobering!

I'd still like to turn my data source into a *simple* LINQ provider if
possible, but lord knows where to start, maybe at the huge walkthrough in
my first link. I found re-linq  which
apparently takes some of the pain of working with expression trees, but I
haven't even found a tutorial on it yet.

Has anyone got experience or comments on this subject?

*Greg K*